Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timing query in a loop
Message
 
 
À
17/03/2005 10:57:43
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
00996779
Message ID:
00996832
Vues:
16
>Ususally a query plan would give you a pretty good idea which query is faster.
>
>Well, as with many computer issues, the difference is there, but too small to see. My point is it may not be visible to me alone, but when 300 users are doing queries, the issue will be magnified.

Mike,

I updated code in my original post. Please check it again in case you didn't see updated version. I added
-- Clear cache buffers 
DBCC DROPCLEANBUFFERS
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform