My symfony application has ~500 users online, and some article list is available on all pages. I store query and result in APC, which is manually deleted by administrator on some data change. Here is the problem:
If i am correct if every of my 500 users refresh the page when cache is deleted and try to renew it (by first query to the database) other 499 are harming the database before the cache is done.
How to avoid this situation? Is there any option in APC that prevents from it, or i need to manage it manually? The best option should be to serve old cache if new is not ready yet.
Unfortunately I'm afraid there is no solution out of the box. If you look at Memcached Bundle they implement a solution to avoid this problem: enter link description here
Maybe you can inspire to write your own solution.