MySQL query cache

Update: on shared web hosting accounts, the cache is almost always disabled and customer has no permission to enable it since it is a global variable. Bummer. I guess this is why people go for Virtual Private Server hosting accounts.

Here is a lovely semi-technical article describing MySQL's unique and bestest feature - the query cache. This speeds up SELECT statements in a big way. Mandatory for high volume Drupal sites.