help: php-cache - too many hits on the DB!

[martincrumlish]

Hi,

I have just developed a web app that puts a heavy load on the database it uses. I have been directed by one of the powers that be to implement some form of caching system to speed things up. I have zero experience of this and I would appreciate some help.

Basically, the web app queries a database for Sports results depending on a selected date. How could I cache this so that the database wouldnt have to be hit all the time to get the data? Any advice at all is greatly appreciated.

Thanks,
Martin

[jerdo]

You could try writing a script that writes a static page and then just having that script on a cron that rewrites the static page every so often.