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!
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.