WebDevTools

Justin Silverton @ The High Performance PHP Blog presents “10 Tips for Optimizing MySQL Queries”:

1. Use the explain command

2. Use less complex permissions

3. Specific mysql functions can be tested using the built-in “benchmark” command

4. Optimize where clauses

5. Run optimize table

6. Avoid variable-length column types when necessary

7. Use Insert delayed where you can

8. Use statement priorities

9. Use multiple-row inserts

10. Use multiple-row INSERT statements to store many rows with one SQL statement.

11. Synchronize data-types

Read the full post here.