It would be really useful if I could extend the time that searches were cached. The following page was not particularly helpful:

http://www.mysql.com/doc/en/Query_Cache.html

Does anyone have any idea about how to store the cache for longer? I am using mysql 3.

It's a mysql 4 feature.

Hi Paul,

When I do an arbritary query, first time round it takes 10 seconds, then the second time it takes 1 second. Surely there is some kind of cacheing going on?

Yup, disk caching. The first time through mysql has to read from the hard drive to get the results. The second time through the o/s has cached this info into memory so mysql gets it straight from memory (much faster).

Also, the indexes get cached as well by mysql.

Cheers,

Alex
--
Gossamer Threads Inc.