DDC-47: Improve query resultset cache control #59

New Issue

admin · 2026-01-22T12:25:34+01:00

admin commented

2026-01-22 12:25:34 +01:00

Originally created by @beberlei on GitHub (Oct 14, 2009).

Jira issue originally created by user jwage:

We need better control for setting the hash/key for resultset cache entries. Then provide a way to clear these cache entries.

http://trac.doctrine-project.org/ticket/2042

$temp = Doctrine_Query::create() 
->from('Profile p') 
->where('p.id=?', $o) 
->setHydrationMode(Doctrine::HYDRATE_ARRAY) 
->useResultCache(true, 3600, 'product_cache') // custom tag 
->execute(); 

$temp = Doctrine_Query::create() 
->from('Model m') 
->setHydrationMode(Doctrine::HYDRATE_ARRAY) 
->useResultCache(true, 3600, 'product_cache') // custom tag 
->execute(); 

$temp = Doctrine_Query::create() 
->from('News n') 
->setHydrationMode(Doctrine::HYDRATE_ARRAY) 
->useResultCache(true, 3600, 'news_cache') // custom tag 
->execute();

and now

$conn  = Doctrine*Manager::getConnection('sqlite_cache*connection'); 
$cacheDriver = new Doctrine*Cache*Db(array('connection' => $conn, 
'tableName' => 'cache')); 

$cacheDriver->deleteByTag('product_cache');

Originally created by @beberlei on GitHub (Oct 14, 2009). Jira issue originally created by user jwage: We need better control for setting the hash/key for resultset cache entries. Then provide a way to clear these cache entries. http://trac.doctrine-project.org/ticket/2042 ``` $temp = Doctrine_Query::create() ->from('Profile p') ->where('p.id=?', $o) ->setHydrationMode(Doctrine::HYDRATE_ARRAY) ->useResultCache(true, 3600, 'product_cache') // custom tag ->execute(); $temp = Doctrine_Query::create() ->from('Model m') ->setHydrationMode(Doctrine::HYDRATE_ARRAY) ->useResultCache(true, 3600, 'product_cache') // custom tag ->execute(); $temp = Doctrine_Query::create() ->from('News n') ->setHydrationMode(Doctrine::HYDRATE_ARRAY) ->useResultCache(true, 3600, 'news_cache') // custom tag ->execute(); ``` and now ``` $conn = Doctrine*Manager::getConnection('sqlite_cache*connection'); $cacheDriver = new Doctrine*Cache*Db(array('connection' => $conn, 'tableName' => 'cache')); $cacheDriver->deleteByTag('product_cache'); ```

admin closed this issue

2026-01-22 12:25:35 +01:00

admin commented

2026-01-22 12:25:36 +01:00

@beberlei commented on GitHub (Oct 15, 2009):

Comment created by 'romanb':

The problematic part here is that APC/memcache/xcache dont have any notion of tags or tagging cache entries. They provide simple a simple key/value store. So we need to work with that.

@beberlei commented on GitHub (Oct 15, 2009): Comment created by 'romanb': The problematic part here is that APC/memcache/xcache dont have any notion of tags or tagging cache entries. They provide simple a simple key/value store. So we need to work with that.

admin commented

2026-01-22 12:25:37 +01:00

@beberlei commented on GitHub (Oct 22, 2009):

Issue was closed with resolution "Fixed"

@beberlei commented on GitHub (Oct 22, 2009): Issue was closed with resolution "Fixed"

admin referenced this issue

2026-01-22 15:56:12 +01:00

[PR #59] [MERGED] Implemented tableName -> className and columnName -> fieldName mapping in DatabaseDriver. #7655

Sign in to join this conversation.