DEV Community

loading...

Discussion on: One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

Collapse
cassidycodes profile image
Cassidy Scheffer (she/her) Author • Edited

These are great tips! Partitioning is the end goal for this table, but we need to do some prep work first.

Interestingly, after running the experiment for a couple days or so the + 0 is much faster both on average and 95p. Seems to be a good stopgap while we work on partitioning, but I want to try out the compound index you mentioned first.