This project is not covered by Drupal’s security advisory policy.

This module is discontinued at the moment.
I am not maintaining any Drupal 5 sites at the moment, so it is very unlikely to have any updates of this module. As to Drupal 6 there are better way of optimizing database problem. If someone wants to take over, please let me know.

Allows users (everyone, including admin) to cache queries for a certain time. It works perfectly with tables like 'system', 'variables', etc. These tables hardly ever change during the standard application life.

Used on high traffic pages (5 million pages per month, 40000 users). Works perfectly well.

This module is useful if you fight with overloaded database server.

Features:
1. Uses CacheAPI or own file storage.
2. Rule based (regular expression) query selection.ys
3. Expires after certain time or on certain events.

FAQ:
Q: Is there some benefit to using this instead of / along with mysql's query cache?
A: Drupal QueryCache module is useful when you want to move load from mysql server to other machines. Some benefits using Drupal QueryCache:

  1. MySQL Query Cache invalidates cache in much more situation
    For more see: http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html
    Drupal QueryCache may cache literally everything, even when the data are stale (i.e. old). But in many cases it really doesn't matter when, for example, user profile view counter will be refreshed every 5 minutes.
  2. From my experience, in some cases, mysql is not able to cope with number of queries (I worked with databases where no of queries per second exceeded 15000), it really doesn't matter whether they are executed or read from cache. Using this module, allowes you to move load from database server to memcache server. Mamecache server can be easliy scale out. You can for example use 10 memcache servers, all you have to do is to add them to setting.php file. When one of memcache server is down it's almost transparent for the application.
    You cannot easily add another database server.
  3. I use Drupal Query Cache with MySQL query cache enabled. There is little or no sense to disable MySQL query cache.

Project information

Releases