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 Comment