It's kinda wild what a little DB tuning can do… On the 6th we launched a new feature that resulted in 100,000's of new DB queries. And because of a single missing index and a few sub-optimal queries, that caused a huge spike in load. We added the index and fixed the queries, and voila!
11 likes 3 replies
?