Caching database queries in memory in PHP

Gauge Point, Bristol

If you have a busy server with repeated database queries, you may wish to use the memcached daemon. This service allows you to store a query's results in memory (and even to share the cache between computers) so that you don't have to keep repeating SQL and disc accesses. Memcached is used on many very busy sites - it's ideal for blog articles (where the recent ones will be cached), images, and so on. This is a demonstration of memcached in use, via a PHP web page. It's provided by Well House Consultants who cover such topics on their PHP techniques workshop or on private courses. You are also very welcome to view the source code (link below) and read a little more about it in our blog here. The home page of memcached is here.