Custom website cache

how should I approach

[wesg]

I'm in the process of building a website that may or may not go fully online sometime. It is heavily dependent on MySQL, but it is not truly dynamic (ie. if it remains static for a few hours, that's fine).

Should the site go online, I'm questioning whether all those queries may bring down the site as it gains popularity. My Wordpress blog has a cache, but this is a fully custom site, so I'm unsure of how to approach it. I've heard or something called Website Cache Compressor, which apparently can do the job.

Any alternatives or suggestions? Ideally, it could be something that refreshes the cache every 6 or so hours so that the data can be updated.

[phranque]

if you are using apache you could do this with mod_cache [httpd.apache.org].

[wesg]

Thanks phranque.

I did a little more research, and decided to build my own cache system using the built in PHP disk buffer.