On Thu, Aug 6, 2009 at 1:45 AM, Michael Wieher <[email protected]>wrote:
> > most databases have a caching mechanism... if your page requires > processing before display, consider caching slow-load pages in a > database and write an algorithm to invalidate this cache only if their > supporting data changes... at this time of invalidation it should be > easy to re-cache the page internally, thus making everyone happy I > hope. > Actually, if you are using Memcache, then you will probably have better performance if you disable the database cache. Assuming you are using mysql, this page will help you disable it (which is quite easy actually) http://dev.mysql.com/doc/refman/5.1/en/query-cache.html Note: Memcached by itself isnt a direct replacement for db query caches, however, proper application of memcached would invalidate most benefits that you get from the query cache. You should run your own benchmarks to see what works best for you. -- "Be excellent to each other"
