Yes, a query cache is only removed when one of it's tables is updated or the server is restarted.
-Eric On Sat, 7 Aug 2004 23:16 +0100 (BST), Terry Riley <[EMAIL PROTECTED]> 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? > > 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] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]