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] ...

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