Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which statement is 'Better'
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6
Divers
Thread ID:
01048319
Message ID:
01377096
Vues:
31
Naomi,

NOLOCK is a sort of last resort item in my book... it typically means that there are so many other things wrong with the database/query design or a seriously underpowered server if you need to use that routinely to fix query performance.

>I remember comment of the previous developer regarding one of the SP (SQL Roles provider). He added NOLOCK hint and indicated that it was for performance reason. Perhaps he observed the same behavior as you do.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform