Re: How should I cache database data for php?

Are you sure that cacheing database data is the right way to approach the problem? How about using a cron job to write static HTML pages from live data? You could set up such a system to run every few hours or so. I haven't done that in PHP, but it's something I'm looking at doing for a Perl project I'm working on. It seems to me that the major problem with news sites such as cnn.com or msnbc.com on dates like 9/11 was the sheer number of visitors coming to the site. No matter how the pages were served up, the load was unbearable for the servers. val petruchek wrote:

Since reading your first post I've been racking my brains/teasing my

memory. I'm sure there's an article on one

of the popular PHP sites that talks about exactly this: creating a web

page dynamically, but serving it as

static HTML (ie with no back-end db access per serving).

This idea came to me after September 11 - many news sites were down because of too many visitors. Some of them refused from dynamic page generation to survive, because huge amounts of visitors looked like hacker attack. In any case this is obvious solution of a problem ;) Valentin Petruchek (aki Zliy Pes) http://zliypes.com.ua mailto:val@zliypes.com.ua

-- Sliante, Richard S. Crawford mailto:rscrawford@mossroot.com http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford MSN: underpope@hotmail.com "It is only with the heart that we see rightly; what is essential is invisible to the eye." --Antoine de Saint Exupery "Push the button, Max!"