The problem with the removePattern() method is that the implementation is not straightforward for some adapter like memcache and APC. There is no other way to implement it for those 2 adapters.
I think your best bet is to create a subclasses of the memcache or APC adapter and implement a SQLite storage for keys you store in the cache, then override the removePattern() method to use the SQLite database to retrieve keys. Fabien -- Fabien Potencier Sensio CEO - symfony lead developer http://www.sensiolabs.com/ http://www.symfony-project.com/ Sensio Labs Tél: +33 1 40 99 80 80 Matthias N. wrote: > Hi, > > I'm playing around with caching in sf 1.1. For example I want to cache > comments. But in my project we have more than 100.000 comments so I > wonder if this is a number that memcache or apc can handle? > > Mostly my problem is that I need to have control over clearing groups > of comments for example all comments of a given answer. > > I noticed that the new caching system has a nice removePattern() > method but I really doubt that the implementation scales well: For apc > it needs to iterate over a huge array containing information about all > keys to get this work and for memcache it also has to iterate over an > array of all keys. > > (Btw: I think that there is a bug in the sfMemcacheCache class in > setCacheInfo(): it should only add a key if it doesn't already > exist!?) > > So.. I just wonder if this is a nice scaling implementation or if it > would be useful to change something as I'm not sure if it is good to > iterate over 100.000 elements each time I want to clear 10 comments.. > > Maybe the performance and scalability is better if we put the keys > into an sqlite database for example and use LIKE to fetch the matching > keys? > > Any thoughts? > > Regards, > Matthias > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-devs?hl=en -~----------~----~----~----~------~----~------~--~---
