Hey I am wondering which would cause least stress on Dreamhost servers.
a) All data loaded from database (roughly 2-4 queries per page)
b) Initially load data from database then cache into text file. When data is changed cache file is deleted then recreated when page is viewed again.
c) Load data from database and cache into text file but set the expiry (to make it load from the database again) to a short period of time (hours or days).This method deletes the cache file when the page is loaded. So it will be there until the page is loaded again (even after the expiry date)
d) any other method you can think of.
As far as all the coding its not a problem all methods are pretty much the same amount of coding. I am more looking to which will perform better on Dreamhost servers if the website becomes popular and had a fair amount of traffic.
Thanks any help is appreciated.