Indexes are THE BOMB

Erin Wagner

I had two back-to-back queries which, together, were taking almost two minutes to run:

114.11 seconds
112.65 seconds
112.15 seconds
113.99 seconds
113.15 seconds

And that's with like 3 test users' worth of data!

I identified 9 potential indexes to apply and decided to measure speed with each one so I could understand what kind of impact they were having.

Applied the first index. Query took 1.33 seconds.

💥💣💥💣💥💣💥

Erin Wagner

For the record, applying the additional 8 indexes had no measurable impact on speed. Either I happened to hit on the critical index first, or the query just needed that little bit of help (to hit warp speed).

Sean Montgomery

Awesome. Indexes are great