This series of articles helps you write high-performance MySQL queries, by poi pitfalls and dangerous misconceptions that developers have.

Name:  viennasql_sample_query.jpg
Views: 8
Size:  12.5 KB

how many times have you found yourself in a situation where your Web application is not performing well? Or, should I say, the database you used isn't performing well? How often have you discovered that the performance issues arise only in the production environment, and you never experience them in the development environment? Or that the query on a good-looking, well-indexed table is taking hours
to complete? This article will help you understand what generally goes wrong, and how to avoid many common and not-50-common traps.