StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POZend Framework, Doctrine and Caching Problems
text
Body
copied!<p>I'm using Doctrine 1.2 with Zend Framework, and it's working just fine. Now I want to start using the results cache and query caching capabilities to reduce the load on DB server that powers the application. Oh, I'm also using Zend_Application and placing code in modules.</p> <p>Anyway, I setup my connections to Doctrine in the overall Bootstrap.php file for the application itself:</p> <pre><code>protected function _initDoctrine() { Zend_Loader_Autoloader::getInstance()->registerNamespace('Doctrine')->pushAutoloader(array('Doctrine', 'autoload')); $manager = Doctrine_Manager::getInstance(); foreach ($this->_options['doctrine']['attr'] as $key => $val) { $manager->setAttribute(constant("Doctrine::$key"), $val); } $conn = Doctrine_Manager::connection($this->_options['doctrine']['dsn'], 'doctrine'); Doctrine::loadModels($this->_options["doctrine"]["module_directories"]); } </code></pre> <p>Now, I spent some time reading both the documentation for query and result caching for Doctrine <strong>and</strong> looking for examples of using Doctrine's caching. What I found appears to be very straightforward. I added this code to the Bootstrap.php file that contains the _initDoctrine() method, inside _initDoctrine()</p> <pre><code> // Set up some caching $cacheConn = Doctrine_Manager::connection(new PDO('sqlite::memory:')); $cacheDriver = new Doctrine_Cache_Db(array( 'connection' => $cacheConn, 'tableName' => 'cache')); $cacheDriver->createTable(); $manager->setAttribute(Doctrine_Core::ATTR_QUERY_CACHE, $cacheDriver); </code></pre> <p>What I am now finding happening is that the entire connection for the application now thinks it is using Sqlite instead of MySQL like it is supposed to. Which seems odd, since I am only setting the ATTR_QUERY_CACHE attribute.</p> <p>Tips on resolving this would be greatly appreciated.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload