<p>i have spent the morning replacing a half dozen single-line sql statements nested in double-deep loops with one 75-line, six table join and cut the response time from north of five seconds to basically zero and this, this!, is what i love about rescue projects. the og team on this spent a month on optimizing this endpoint. they had four memoization arrays. they bought a bigger ec2.</p>