Re: How to use Query Cache with Perl DBI

[Bill Karwin]

Right, listen to David, you need to enable the query cache. It's disabled by default. See docs at http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html

Also note that the query cache will not cache prepared statements. That is, the following SQL statement can never be cached, because the result set is variable depending on the value of the parameter:

SELECT * FROM mytable WHERE column1 = ?

See other rules for what types of queries can/cannot be cached here: http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html

Regards,
Bill K.