MySQL Forums
Forum List  »  Perl

Query Cache and Perl
Posted by: T N
Date: January 03, 2006 03:27AM

Hi,
I'm using DBI to connect to MySQL 4.1 in Perl.

In the MySQL manual (Section 5.12) it says :
"Note: The query cache is not used for server-side prepared statements. If you are using server-side prepared statements consider that these statements will not be satisfied by the query cache. See Section 18.2.4, “C API Prepared Statements”."


Is Perl DBI using these "server-side prepared statements", or can I use the query cache?

My code is using the syntax where is says "prepare" like this:
my $sth = $dbh->prepare("SELECT * FROM table");
$sth->execute();
my $rs = $sth->fetchrow_hashref();
.....

Greetings,
TN

Options: ReplyQuote


Subject
Written By
Posted
Query Cache and Perl
T N
January 03, 2006 03:27AM


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.