Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Performance when multiple users connected to same ta
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00718739
Message ID:
00718747
Views:
30
>There is a measurable difference in performance when more than one person is accessing a VFP database. The test that I used is a procedure looping through the largest table we have using an index. The procedure was setup to run simaltaneous on two workstations at the same time.
>
>What if anything can be done to better manage this issue.

If you dont need update access, open the table with USE .. NOUPDATE, that will speed access as no locking / changes detection takes place.

Regards,
------------------
Jose Marcenaro
Tercer Planeta - Argentina
http://www.tercerplaneta.com
Previous
Reply
Map
View

Click here to load this message in the networking platform