Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sudden slow database access
Message
 
To
19/01/2015 09:15:48
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01613560
Message ID:
01614133
Views:
42
>That is the classic behavior of the oplocks. It starts out giving the only user "exclusive" access. When the second user joins, the first users exclusive changes to shared. Then all users are equally slow. THAT is the normal. Exclusive use is an exceptional case and you will never get that performance across the shared users. The best thing is to disable oplocks and optimize for shared access. 15 seconds may be something you can really cut down on.
>

Mike, is there a way to programattically determine if oplocks is on/off?

Is it your experience that turning off oplocks has a particular success rate for improving performance? Usually? 50/50?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform