Re: How to use Query Cache with Perl DBI

[Bill Karwin]

As it turns out, no usage of prepared statements can be cached.

See http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html:

Quote

A query also is not cached under these conditions:
. . .
It was issued as a prepared statement, even if no placeholders were employed. For example, the query used here is not cached:

char *my_sql_stmt = "SELECT a, b FROM table_c";
/* ... */
mysql_stmt_prepare(stmt, my_sql_stmt, strlen(my_sql_stmt));

Regards,
Bill K.