[bigbee]

The easiest way is to use MySQL's own query cache. Increasing its size yields wonderful results.

On linux, edit my.cnf and add the following:

  [mysqld]
  ...
  query_cache_type=1
  query_cache_limit=1M
  query_cache_size=128M # or more - depends on you total  available RAM
  key_buffer=128M # or more

Note that you'll need to restart mysql to make these changes count