Blog

Published by Baron Schwartz on Sep 21, 2017 4:31:49 PM

Find Queries That Need Indexes With VividCortex

Queries can be slow or resource-heavy for many reasons, but one of the most common is that the table doesn't have a good index for the query. This is true for MySQL, PostgreSQL, and especially for MongoDB. Adding an index where it's missing is often a night-and-day improvement, as shown in this screenshot of a query's performance. The index was added midway through the time range, and the query got dramatically faster:

Read More

Recent Posts

Subscribe to Email Updates

Posts by Topic

see all