Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way on Updating a SQL file
Message
From
20/03/2004 05:31:42
 
 
To
19/03/2004 15:48:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00888043
Message ID:
00888177
Views:
8
Craig,

try this:

open the view,
open Query->Advanced Options
Set:
Number of records to batch update to 5 or more
this reduce the
- round trips
- SQL compilations
- SQL lock context builded
for do the update task.

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform