in reply to Re: Database driven web content: live or tape?
in thread Database driven web content: live or tape?

I think the solution that's presenting itself now (after more coffee and some thought) is one where I go to the cache for each page .. if there's no hit, I go to the database.

Whenever the database gets updated, I flush the cache.

So that's the best of both worlds .. database driven, but cached until the database gets updated.

Thanks to all for their thoughtful replies!!

--t. alex

"Mud, mud, glorious mud. Nothing quite like it for cooling the blood!"
--Michael Flanders and Donald Swann

  • Comment on Re: Re: Database driven web content: live or tape?

Replies are listed 'Best First'.
Re^3: Database driven web content: live or tape?
by Aristotle (Chancellor) on Jul 19, 2002 at 20:39 UTC
    If you mean invalidating the entire cache for each update, I'd strongly recommend you use an invalidation scheme that at least affects only parts of your cache, if restricting it to just the one affected page is not possible. Otherwise, esp if your site contains a lot of relatively seldomly visited and seldomly updated pages, you'll reap much less benefit from caching than possible.

    Makeshifts last the longest.