Recently we were contacted by an educational software company that needed immediate help analyzing their website performance and implementing a quick fix. We really love this kind of challenge and agreed to take a look.
We focused on the slowest queries in New Relic and identified each could be sped up significantly by adding missing indexes. We also observed that the app’s database had been built with almost no indexes at all - so there's more room for improvement.
Paying attention to your database design and including the appropriate indexes can make a big difference in your app’s ability to grow and handle more users. In this particular case, some queries went from averaging up to 1 second execution time to consistently averaging less than 10 ms (ten thousandths of a second).
Here's what our client reported:
"New Relic shows significant improvement with database queries, perhaps 60-80% less time overall (see attached). I can feel it as an end-user. Much better performance, thank you!"
Join The Conversation
More On The Blog
What open source can offer eCommerce sites.
In this article we will be looking at the most typical categories to choose from and giving you our take on what open source can do for your brand.
Alejandra Renteria — Sep 24, 2020
Grocery eCommerce: insights for the future of supermarkets.
In this article we'll take a closer look at trends and success factors driving the grocery eCommerce industry forward.
Alejandra Renteria — Sep 22, 2020
Preparing your site for the best Q4 ever
In this article we’ll look at key steps to take for planning this holiday season, the importance of optimizing your site for a unique customer experience and conversion rate, in preparation for your best Q in 2020.
Alejandra Renteria — Sep 17, 2020