Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sudden slow database access
Message
 
À
19/01/2015 09:15:48
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01613560
Message ID:
01614133
Vues:
41
>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform