Caching MySQL queries

This is a great overview of how to cache queries in MySQL:

• The MySQL Query Cache

You can use Zend Cache to cache results of your queries among other things.