Re: Query cache question when using HANDLER

2007-06-27 Thread Jim Winstead
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote: > Are HANDLER queries cached in the query cache? No, they are not. The query cache only caches the results of SELECT statements. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Query cache question when using HANDLER

2007-06-27 Thread Ian Collins
Hi, I have an application that is using the MySQL HANDLER heavily. The application was ported from a legacy ISAM database to use MySQL. The upshot is that the application works by "index walking" - i.e., HANDLER tablename OPEN HANDLER tablename OPEN as indexname HANDLER indexname READ indexname