Re: How to use Query Cache with Perl DBI
Posted by:
Bill Karwin
Date: September 02, 2006 11:25AM
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.
Subject
Written By
Posted
September 01, 2006 10:20AM
September 01, 2006 10:56AM
September 01, 2006 11:11AM
September 01, 2006 08:38PM
Re: How to use Query Cache with Perl DBI
September 02, 2006 11:25AM
September 02, 2006 10:02PM
September 02, 2006 10:37PM
September 03, 2006 12:21AM
September 03, 2006 07:07AM
September 03, 2006 10:25AM
September 03, 2006 11:15AM
September 03, 2006 09:20PM
September 03, 2006 11:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.