TalkPHP - View Single Post

Brook · 12-08-2007, 04:44 AM

Hi All - I'm just getting into php, and was hoping if you could help me with a few things :)

My main question right now is, should I use some kind of page caching to save the database getting hit so much?

All the scripts I am going to write are probably ok to be updated every 10 minutes, so I was thinking of outputting the final html and caching that and then displaying the cached data/html to the end user. Then perhaps set-up a cron to update the cache every 10 minutes.

Is that a good idea? I figured that rather than the DB get XX amount of queries every second/page view, I thought once every 10 minutes would be easier on the server?

Do you think I am worrying too much?

The pages are basically going to call data from vBulletin and there will be about 22 to 26 queries in total per page.

Your help and thoughts apreciated!

(ps I like the wider layout here!)

12-08-2007, 04:44 AM	#1 (permalink)
Brook The Acquainted Join Date: Jul 2005 Location: UK Posts: 121 Thanks: 41	Cache or not to cache? Hi All - I'm just getting into php, and was hoping if you could help me with a few things :) My main question right now is, should I use some kind of page caching to save the database getting hit so much? All the scripts I am going to write are probably ok to be updated every 10 minutes, so I was thinking of outputting the final html and caching that and then displaying the cached data/html to the end user. Then perhaps set-up a cron to update the cache every 10 minutes. Is that a good idea? I figured that rather than the DB get XX amount of queries every second/page view, I thought once every 10 minutes would be easier on the server? Do you think I am worrying too much? The pages are basically going to call data from vBulletin and there will be about 22 to 26 queries in total per page. Your help and thoughts apreciated! (ps I like the wider layout here!) __________________ PS3 Forums on GameSlurp - the site for gaming fans!