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:
- Using TOP in MySQL queries On the web I see a lot of questions of...
- Usefull MySQL articles and tutorials to improve your skills! As promised in my previous post with usefull PHP articles...
- 11 MySQL resources you must read! Conditional joins in MySQL One way to do a “Conditional...
- 15 essential PHP and MySQL tutorials! Showing Google Maps with many markers in PHP Sometimes you...
- Useful PHP and MySQL articles to improve your development skills! CakePHP Authsome Authentication for people who hate the AuthComponent. Triggering...
Related posts brought to you by Yet Another Related Posts Plugin.