Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Shared Command in VFP 9.0
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01342480
Message ID:
01342981
Views:
12
Hi Andrew,

> Shared is now slower than Exclusive.

As all others have stated, shared is always slower than exclusive. Aside from the locking the other reason is that VFP caches write operations with exclusively opened tables. Depending on the amount of your modification, VFP might only write to the server when you close the table. In shared mode, VFP writes every record immediately.

It's strange that you have such a huge difference between VFP 8 and 9. It's not like Microsoft did a major rewrite in VFP 9 of the data handling code. I would assume both to operate at rather similar speeds.
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform