about:benjie

Cake caches database queries. This is good, generally, it speeds things up a lot. But it is not always good. For example, if I want to query the database once a second to look for updates (e.g. for my chat application) the you don’t want the cache. Here’s how to clear it:

1) Create /app/app_model.php, and add in it the following

<?php

class AppModel extends Model{
function _clearDBCache() {
$db =& ConnectionManager::getDataSource($this->useDbConfig);
$db->_queryCache = array();
}
}

Note: you don’t always need a close "?>"

2) Call $modelNameHere->_clearDBCache() whereever you need the DB cache cleared.

That’s it! Have fun!

Whilst I am on the subject of CakePHP tips, why not look into using expects() to make your CakePHP queries more efficient – only request the data you need. Much better than using unbindModel and bindModel all over the place!

This entry was posted on Friday, June 29th, 2007 at 6:57 pm by Benjie and is filed under CakePHP, Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.