Caching data in PHP

caching, php

Solution

Use any of these for caching backends:

- http://php.net/manual/en/book.apc.php

- http://memcached.org/

- http://xcache.lighttpd.net/

and use Zend_Cache for a unified interface to them

- http://framework.zend.com/manual/en/zend.cache.html

Whether to use full page caching or partial caching depends on your specific UseCases. Usually, your application will have a mix of both.

Problem

I'm developing a site in PHP which has some complex SQL queries and I would like to implement a caching feature to reduce the load on the database. I'm just wondering would it be better to write and read HTML directly to a file or perhaps create something like a YAML file with a delimiter to separate records then wrap it in HTML with a function? My thinking is that this would allow user options (for example, number of records to display) to be applied to the request. Any advice / suggestions appreciated. Thanks.

Original source