Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem of SQL passthrough
Message
From
23/09/2003 01:08:39
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russia
 
 
To
22/09/2003 23:45:22
Stanley Yip
Shun Sang (technology) ltd Hong Kong
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00831316
Message ID:
00831326
Views:
20
do you mean under loop the loop for records from client side cursor updating each record to server? If so, you can make it much faster using asinchronous transaction
Set it before loop nad do sqlcommit after 25-50 records ( may be 100) and one sqlcommit after loop, if res number of records are not devided on 25-50
This number should be found experimentally and depends from numbers and types of fields to update, free memory etc.
Do forget to set transaction to normal after circle.
Best wishes, Vladimir.
MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform