Just came across this great article with 20 best practices when using MySQL: MySQL best practices.
Be sure to check them, the following items are in the article:
- Optimize Your Queries For the Query Cache
- LIMIT 1 When Getting a Unique Row
- Get Suggestions with PROCEDURE ANALYSE()
- Prepared Statements
- Split the Big DELETE or INSERT Queries
- Be Careful with Persistent Connections
And more tips!
Related posts:
- Usefull MySQL articles and tutorials to improve your skills! As promised in my previous post with usefull PHP articles...
- Using TOP in MySQL queries On the web I see a lot of questions of...
- Useful PHP and MySQL articles to improve your development skills! CakePHP Authsome Authentication for people who hate the AuthComponent. Triggering...
- Great tips to improve your MySQL performance Some great articles on how to improve the performance of...
- A MySQL mojo leaves Oracle Ever since Oracle closed on its acquisition of MySQL, the...
Related posts brought to you by Yet Another Related Posts Plugin.