Top 10 MySQL Tips and Tricks
1) Optimize your WHERE clause. Remove unnecessary parentheses, this will speed up evaluation COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM…
Read moreMySQL Foreign Key Night-mare
I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB…
Read more