MySQL 5.1 fixes prepared statements

Its been a long wait. Yesterday I discovered that MySQL 5.1 is generally available. And the good news is prepared statements in mysql 5.1 can utilize the query cache :-)

Previously, the most elegant work around when issuing prepared statements from PHP was to emulate prepared statements client-side using PDO. The other obvious alternative is to not use prepared statements!

If you’re not using prepared statements maybe you should take a look. It’ll save you. Promise. MySQL 5.1 is generally available but I’m not so sure the package maintainers have got a chance to include it into the major distros as yet.

If you’re still on MySQL 5.0 or less… beware! Prepared statements are not stored in the query cache :-(

Published in: on February 6, 2009 at 10:41 am  Comments (1)  
Tags: , ,

The URI to TrackBack this entry is: http://phpslacker.com/2009/02/06/mysql-51-fixes-prepared-statements/trackback/

RSS feed for comments on this post.

One Comment Leave a comment

  1. [...] the rest here: MySQL 5.1 fixes prepared statements Related ArticlesBookmarksTags Using PHP and MySQL to Develop a Simple CMS – Version 1 In [...]


Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>