Automatically rebuild cache

I run a Symfony 1.4 project with very large amount of data. The main page and category pages are using pagers which need to know how much rows are available. I'm passing a query which contains joins to the pager which leads to a loading-time of 1 minute on these pages.

I configured cache.yml for the respective actions. But I think the workaround is insufficient and here are my assumptions:

Symfony rebuilds the cache within a single request which is made by a user. Let's call this user "cache-victim" to simplify things.

In our case, the data needs to be up-to-update - a lifetime of 10 minutes would be sufficient. Obviously, the cache won't be rebuilt, if no user is willing to be the "cache-victim" and therefore just cancels the request. Are these assumptions correct?

So, I came up with this idea: Symfony should fake the h开发者_StackOverflow社区ttp-request after rebuilding the cache. The new cache-entries should be written on a temporary file/directory and should be swapped with the previous cache-entries, as soon as cache rebuilding has finished.

Is this possible?

In my opinion, this is similar to the concept of double buffering.

Wouldn't it be silly, if there was a single "gpu-victim" in a multiplayer game who sees the screen building up line by line? (This is a lop-sided comparison, I know ... ;) )

Edit

There is no "cache-victim" - Every 10 minutes page reloading takes 1 minute for every user.

I think your problem is due to some missing or wrong indexes. I've a sf1.4 project for a large soccer site (i.e. 2M pages/day) and pagers aren't going so slow even if our database has more than 1M rows these days. Take a look at your query with EXPLAIN and check where it is going bad...

Sorry for necromancing (is there a badge for that?). By configuring cache.yml you are just caching the view layer of your app (that is, css, js and html) for REQUESTS WITHOUT PARAMETERS. Navigating the pager obviously has a ?page=X on the GET request.

Taken from symfony 1.4 config.yml documentation:

An incoming request with GET parameters in the query string or submitted with the POST, PUT, or DELETE method will never be cached by symfony, regardless of the configuration. http://www.symfony-project.org/reference/1_4/en/09-Cache

What might help you is to cache the database results, but its a painful process on symfony/doctrine. Refer to: http://www.symfony-project.org/more-with-symfony/1_4/en/08-Advanced-Doctrine-Usage#chapter_08_using_doctrine_result_caching

Edit: This might help you as well: http://www.zalas.eu/symfony-meets-apc-alternative-php-cache