DN, Yes the db server and the webserver are on the same box, local connections are much faster than network ones according to mysql. When the site is busy the percent of the system being used by mysql and that being used by PHP/Apache, I estemate would be around 90%-10% so if I get the db load down I'll have smooth sailing.
I'm not attempting to elimate the compalition of PHP, I just want to eliminate some database queries. I don't particually care for the idea if writing static html files. I've had really bad experiences with stale files our old system. The way I'm exploring now is to build a caching layer between the php application and mysql. I want the app to query the caching layer just about the same way it queries the database, but add a few other details, time to live, cache name etc. The caching layer will check to see if the query is cached, make sure it's not expired, and return the data just like a result set from the db query. If it is expired, or doesn't exist then it will query and create the cache file for next time. I'm leaning toward storing the data in XML, and kicking around the idea of storing it on a ram disk so it would have killer fast access time. I expected to get tons of links to libraries or other apps that have data caching, I'm quite supprised that I haven't yet. On Mon, 2002-01-21 at 14:20, DL Neil wrote: > Jeff's original post mentioned reducing load on the db server - are the db and web >servers on the same physical > device - and thus his concern? > - or perhaps if there are other apps needing to 'compete' with the web server to >gain access to the db > concurrently? > -- 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]