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. [...]

[Read more →]