So today in playing with doctrine in one of my projects I decided to enable query caching to help speed up things a bit. My current host does not run APC or MemCache so I had to use sqlite memory table which they do allow. I followed the directions as stated in the manual for 1.2, but it didn’t work. It gave me a Table name option not set.
To fix this problem, I played around a bit and came up with the following fix.
$manager = Doctrine_Manager::getInstance();
$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);
Please leave a comment if i missed anything or there is a better way of doing something.
