Clearing Cache

[Mike Goodwin]

Hi,

Is it possible to clear the query cache? For the purposes of comparing
query performance.

Even restarting the database does not seem to work, so they must be
getting cached to disk,

thanks,

Mike

[Noel Grandin]

We don't store our query cache to disk.

But the operating system will be caching disk contents itself, which
will make a large difference.

You could try clearing the operating system disk cache, but you'd have
to have to google around to figure it out for your OS.

[Steve McLeod]

In OS X, open up the Terminal, type the command "purge" at the command line, and then press Enter. This will clear the memory cache to help when dealing with this situation.

Regards,

Steve 

---------------------------------------------------

Steve McLeod

Founder, Poker Copilot

http://www.pokercopilot.com

[Mike Goodwin]

Ok. It must be something like that then.

(Although my experiences usually that query times are very stable and
repeatable. Often 20% slower or so on the first run and then they
settle down. In this case I was experiencing a dramatic speed up from
about 10s to just 100ms.)

- mike

[Mike Goodwin]

I am on Windows 7 I'm afraid! (I'm sure it will help someone else however).

(Actually I'm trapped on windows by the greatness that is home row
computing[1] using autohotkey. Windows 7 has blue screened on me
several times - and then not booted without a reinstall (it is like
living in the 90s!), but I am still here on it...).

[1] http://duartes.org/gustavo/blog/post/home-row-computing