SQL performance improvements: automatic detection & regression testing (part 3)
This is the final part of our 3-part series on SQL performance improvements. In part 1, we covered how to identify slow queries. In part 2, we explored how to fix them with indexes. In this post, we'll share how we prevent those performance issues from ever reaching production again. A few weeks ago, we massively improved the performance of the dashboard & website by optimizing our SQL queries.