Re: clearing the buffer cache

> With recent versions of Linux you can flush the system's buffer cache by
> doing:
>
>   # echo 3 > /proc/sys/vm/drop_caches

You can also try something like this:
http://wiki.services.openoffice.org/wiki/Cold-start-simulator

Shutting down the server and running fillmem has worked for me, but that
might take too long in your situation of thousands of small queries. But
I guess "SELECT * FROM large_table" would have taken just as long anyway.

--Chris