Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem of SQL passthrough
Message
De
23/09/2003 01:08:39
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
 
 
À
22/09/2003 23:45:22
Stanley Yip
Shun Sang (technology) ltd Hong Kong
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00831316
Message ID:
00831326
Vues:
21
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform