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 -~----------~----~----~----~------~----~------~--~---
