Hacking with PHP has been updated for PHP 7 - click here! >>

Optimise your tables

The SQL statement "OPTIMIZE TABLE table " lets you specify a table (or several tables, with commas in between) that you would like MySQL to optimise. Notice the spelling is with a Z in the statement. By "optimise", I mean tables that have had a lot of changes made to them since they were created - lots of rows added/deleted/edited, etc; especially if the table uses varying length fields like VARCHARs and TEXTs. OPTIMIZE TABLE instructs MySQL to basically defragment the table to make it faster to read and write from.


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

Next chapter: Select as little data as possible >>

Previous chapter: Prioritise your data

Jump to:


Home: Table of Contents

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