Optimizing MySQL queries

One suboptimal database query can effectively paralyse whole application. Tracking down such bottleneck is one thing but speeding it up is not a trivial task. This article is intended to show how one can analyse and refactor slow database query. In all examples I was using MySQL Workbench and Sakila example database. DB’s structure is […]

Read More