-
disable caching
hi,
just need help to find a way to disable caching.
well let's say I'm runniung a Select command on a big table.
the first time it is running you can see the real time that server takes to deliver the results. but if you run it again it will use the catch and the responce is almost without any delay.
is there any setting that I can disable caching( temp.) for a test I'm doing
many thanks
Ciao
S
-
You can't disable caching but you can clear the cache after first run using
dbcc dropcleanbuffer
command. It works in SQL 2K only.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|