At 23:16 +0100 8/7/04, Terry Riley wrote:
We have the query cache turned on, and it appears to be working well.
However, there appears to be no indication in the manual as to the time
that a cached query remains in memory. In the absence of this information,
is it safe to assume that a cached query remains there indefinitely,
unless either (1) one of the tables used in the initial query is modified,
or (2) the server is re-started?
Yes. Why would you remove a result from the cache if it's still current?
Actually, there is another condition:
(3) you issue a RESET QUERY CACHE statement, which clears the
entire cache.
We are using ColdFusion MX, which has its own query cache (which is very
useful for whats called Query-of-query selects), but there the residence
time is configurable, and the timer is restarted if the cached query is
called before the timeout.
Regards
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]