Jay Pipes writes about MySQL Connection Management and caching in PHP.
This small tutorial will help you understand the MySQL Connection Management and caching in PHP.
FTA, "This article is intended to highlight various basic topics concerning proper methods of handling connections to MySQL databases in PHP, guidelines for caching dynamic content, and a technique called "lazy loading". Hopefully by the end of the article you'll have learned how to combat a very widespread and potentially devastating scalability problem seen in an enormous number of PHP web applications"
Read more at jpipes...
On a related note MySQL Performance Blog also covers caching techniques such as:
- TTL Based Caching
- Cache Invalidate
- Cache Update
- Version based caching