> Well, if you're caching but having your content updated twice a day > wouldn't you be better off letting the db take the strain? I don't see > how else you are going to make sure people are seeing the latest content > as opposed to cached pages that are out of date. Let your db do the > work, that's what it's for :)
But at 300,000 page views a day, even if the caches only have a ttl of 1 hour I'm still saving over %90 of the traffic from having to query the database. During our busy times I have a bottle neck with the database maxing out the CPU's, so If I can cut the queries the server won't be working as hard, plus file I/O is faster than Database I/O so the site will be faster even when it's not busy. > One of the 'home grown' solutions I saw was to 404 page to trigger the > creation of a static html page made from the results of the first query > on the db. The problems I saw though were: What about browser compat > issues and what a pain that would be to have to wipe the 'cached' static > dir every time you updated your content. > It seemed well suited to articles that wouldn't alter much over time > though. (I think the piece was on www.devshed.com) OK I'll look into it,those are the kind of ideas I'm looking for, eventhough I agree, that one doesn't sound like much fun. and I'm not worried about ppl getting errors, I'm worried about them getting the page fast. now it can be slow, but no errors. > > > - -- > > Nick Wilson > > Tel: +45 3325 0688 > Fax: +45 3325 0677 > Web: www.explodingnet.com > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6 (GNU/Linux) > > iD8DBQE8TDtzHpvrrTa6L5oRAu+rAJ0bArR4ohvbvCE4kC6DzqtMe3CvRQCfbBHl > Sqy+StTmXNzDgHwZ7PabIH0= > =xj8f > -----END PGP SIGNATURE----- > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
