MySQL Forums
Forum List  »  Performance

Re: Question about the Query Cache and server settings
Posted by: Jay Pipes
Date: July 24, 2005 09:56AM

The Query Cache *WILL NOT* cache any query issued using the prepared statement API. So, in effect, if you know that a SELECT query is expensive and called repeatedly, don't use the mysqli prepared statement API.

Use the prepared statement API for *repeated* INSERT/UPDATE/DELETE statements, however. This will improve performance substantially, and since INSERT/UPDATE/DELETE queries are never cached by the query cache, there is no conflict of interest.

Glad you brought that up, Andrew!

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Question about the Query Cache and server settings
1743
July 24, 2005 09:56AM


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.