This is part 2 of a 3-part series on SQL performance improvements. A few weeks ago, we massively improved the performance of the dashboard & website by optimizing some of our SQL queries. In this post, we'll dive deeper into the optimisations of queries with indexes. Table of contents: Ways to improve database performance How database indexes work Let MySQL explain why a query is slow Different EXPLAIN output Adding indexes Multiple indexes vs. composite indexes The order of the index vs. the...
