Improve result cache

Would an use case as followed be also considered?

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

So multiple tags could be used as "labels" for an cache instance?

Not really. The cache drivers only have the ability to store key => value pairs so we're limited on what we can provide in Doctrine natively.

I think, that each driver should store also cache metadata (that's the behaviour of symfony's cache system)..

In the cache should be sotred also the cache_info key that should be an array of cached keys each index of an array should be the tag name and each tagname should contain multiple cached_keys.

{{{
$cacheInfo = array(
'product_cache' => array('sql_1_key', 'sql_1_key_paged', 'sql_2_key', 'etc' ,'etc'),
'brands_cache' => array('sq_1_key', 'sql_3_key')
);
}}}

The deleteByTag method should also be able to compare the tag against regular expression...

Please remember we are limited by what the cache drivers can do. We can only store key => value pairs and can only select and delete one key at a time. No deleting by regular expression or anything like that. All your above suggestions are great idealistically but are impossibly to implement so we need to keep that in mind.

Jon, have you ever seen the sf*Cache classes?

Please, look at http://trac.symfony-project.org/browser/branches/1.2/lib/cache/sfMemcacheCache.class.php especially on methods set, setCacheInfo, removePattern. I know that the drivers doesn't have functions for regexp searching. Therefor I am suggesting to store also the cache info as symfony does.

I will create some patches in a few days...

Ok. I understand now. i think we can implement something similar where we just maintain our own list/index of all the keys we've cached so that we can perform regex deletions. I have some patches that I will commit today because I want to release alpha3 asap.

I committed some changes that now allow you to delete by regular expressions. We need to test this asap so that I can release alpha3 tomorrow morning.