Upgrade MySQL

The developers of MySQL make big leaps forward with each release, and regularly address the issue of performance. MySQL 4 brought with it the new query cache, which stores the results of each of your SELECT queries in RAM. If the same query comes in again and the table hasn't changed, MySQL will simply load the result from RAM and return that - much, much quicker than having to perform the whole query from scratch.

If you do a lot of SELECT queries, and have queries that return the same results all the time or even some of the time, the query cache will raise your performance substantially.


Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Increase your buffers >>

Previous chapter: Normalisation

Jump to:


Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.