|
Wednesday, 03 October 2007 |
Query Cache is here! This component caches MySQL queries before the database even sees them! I've witnessed a site go from 175 queries executed to 21 queries after enabling Query Cache! The best part... It works for ALL users, no matter if they are logged in or not!!! There is no worry that cached data will get stale, because the component monitors write queries, and will clear the cache for tables that have been written to!
Because this system uses memory based caching, you must have one of the following installed on your system to use Query Cache
--APC
--XCache
--Memcached
You can also write your own backend storage method and plug it in!
Note! there are 2 different versions of this component. One for Joomla 1.0, and one for Joomla 1.5. Make sure you use the right version!
See the FAQ for more info http://www.joomlaperformance.com/component/option,com_easyfaq/task,cat/catid,39/Itemid,7/
NOTE! This component works fine with PageCache! BE AWARE! DO NOT ATTEMPT TO USE PAGECACHE WITH DATABASE CACHING (all others work fine) WITH THIS COMPONENT. You have been warned.
USE WITH CAUTION! This component is EXPERIMENTIAL. DO NOT USE ON A LIVE SITE! Backup first!!!
Beta 4 is now out! At this pace, it'll be stable by next week! (just kidding)... Give it a shot! The major bugs are gone now... (with any luck)
Read more at: . |