I had a rails/ar based report that I "fixed" at my last job that when it ran it generated 1100 reads (not even N+1, a lot of other crazy aggregates, etc).
It was complicated, but I got it into one query, subquery and a partition.
Went from 45s of app time to process to a <1s query!
I had a rails/ar based report that I "fixed" at my last job that when it ran it generated 1100 reads (not even N+1, a lot of other crazy aggregates, etc).
It was complicated, but I got it into one query, subquery and a partition.
Went from 45s of app time to process to a <1s query!