Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-users drops speed by 80%?
Message
 
To
30/04/2002 08:51:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00650803
Message ID:
00650810
Views:
27
Pascal,

The slow down is probably due to the fact that the transaction takes locks on everything it touches before it commits. Your best approach to attqack this problem will be to use buffering, and then do all processing of data before you strat the transcation. Inside of the transaction you shoudl have only Tableupdate() calls. This will reduce the time of the transaction to its minimum and also the possibility of collisions to a minimum.
Previous
Reply
Map
View

Click here to load this message in the networking platform