On Mon, 2007-07-30 at 11:44 +0800, K J wrote: > There are portions of my PHP application that updates every 5 minutes > or so. Thus I think it's a great candidate for caching, as opposed to > having the server refresh that portion every time there's a query.
Yes, there's huge benefits to be gained from it. > > As far as I'm aware, there isn't a PHP partial page caching available > is there? Using an engine such as Smarty (smarty.php.net) gives you more granular control of caching page elements, but I'm not exactly sure what you want to cache. > > So, I'm thinking of using Memcache instead. Now, I can cache the SQL > queries, or I can cach that portion of the page (with html rendered). > However, if caching that portion, it would mean more internal LAN > traffic for every page view request. Often SQL query caching isn't hugely beneficial as your database server most likely caches pretty well. Caching HTML portions to reduce database queries will most likely give you a huge performance benefit. Do you currently have issues with LAN traffic that make you think using memcache will be a problem? You need to move a lot of data around to saturate a gigbit switch. You may also consider a sole memcache instance per web server, whereby traffic would not leave the server, which may help if you have network saturation issues. Thanks, Rob. Rob Sharp Development Lead telephone: 02 9282 4049 facsimile: 02 9282 4099 skype: qu4nnum Sound Alliance inthemix : FasterLouder : Thought By Them : SameSame 100% recycled electrons were used for the composition of this email - please don't print it unless you need to!
