yet another g33k blog *sigh*

MySQL 5.1 fixes prepared statements

with one comment

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 :-(

Written by phpslacker

February 6, 2009 at 10:41 am

Posted in mysql, php

Tagged with , ,

One Response to 'MySQL 5.1 fixes prepared statements'

Subscribe to comments with RSS or TrackBack to 'MySQL 5.1 fixes prepared statements'.

  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