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!"
Let's work together
Tell us about your project and we'll get back to you shortly.
Join The Conversation
More On The Blog
8 Best Ruby On Rails Gems For eCommerce Applications
Everyone within the eCommerce space knows of Ruby On Rails. This framework is used by approximately 3,866,870 websites right now, showing just how efficient it can be for creating efficient yet beautiful web applications. Now, this unique Ruby-based framework comes with its fair share of add-ons and extra features to discover as well. One of the most important ones is the gems in Ruby On Rails.
Sol Dieguez — Nov 30, 2022
How To Improve Your eCommerce With PHP
With the ever-changing state of the IT industry and the fluctuating eCommerce development trends, it’s more than necessary to be flexible in trying out different tech stacks for your eCommerce site. Now, PHP is one of the most popular programming languages out there, and one with a long-standing track record.
Sol Dieguez — Nov 24, 2022
Tips For Getting The Most Out Of Your AWS Free Tier
This cloud computing service currently has over one million users, with enterprise-scale customers making up about 10% of their clients. This shows just how widely used AWS is and gives a solid reason to try it out: it seems to work for most eCommerce businesses out there. Now, there’s a way to check out AWS for free and see if it works for your online business.
Sol Dieguez — Nov 18, 2022