10 sats \ 1 reply \ @beorange 14 Jul 2023 \ on: That moment when you increase query performance by 600x by adding two characters tech
Looks like a good deal.
Good job, finding that index (or creating it).
The index already existed, I just had to use
ORDER BY m.ts DESC instead of ORDER BY ts DESCreply