Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timing query in a loop
Message
 
 
To
17/03/2005 10:57:43
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
00996779
Message ID:
00996832
Views:
17
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform