It’s interesting that if you read through the Zend dB manual, they mention a big problem with Zend Framework, namely that since Zend uses prepared statements, if you’re running a pre-5.1.17 version of MySQL, you give up the benefits of MySQL’s query cache. They also provide the solution in one of their examples, but they neglect to tell you that it solves the problem.
If you look at example 11.7:
$pdoParams = array( PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true );
you will find setting this parameter when starting the connection turns on the query cache.
2 responses so far ↓
Danilo // December 3, 2009 at 6:52 pm
I had this same problem, you need to replace the DLL from a DLL php_pdo_mysql.dll unofficial found on this site: http://www.emilianbalanescu.ro/tshirtshop/pdo_driver/php_pdo_mysql.dll
Good luck
Joe Devon // December 5, 2009 at 4:47 pm
Have you got some backup to show that the link is legit? (I didn’t follow the link myself…) If no one comes through w/ some proof I’m going to put the post back into spam…