Results 1 to 3 of 3

Thread: disable caching

  1. #1
    Join Date
    Aug 2003
    Location
    London
    Posts
    110

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't disable caching but you can clear the cache after first run using

    dbcc dropcleanbuffer

    command. It works in SQL 2K only.

  3. #3
    Join Date
    Aug 2003
    Location
    London
    Posts
    110
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •