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:
- Best practices for organic SEO I found a very cool presentation about SEO, the following...
Related posts brought to you by Yet Another Related Posts Plugin.