26
SQLite improving performance with pre-sort
(andersmurphy.com)
Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!
Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.
Hope you enjoy the instance!
Rules
Follow the wormhole through a path of communities !webdev@programming.dev
I don't know much Clojure, but this should be doable in Java. I would be interested in seeing the results of sorting the data via both quicksort and heap sort. I'm not sure what sort Clojure defaults to, but if the distribution of IDs is uniform, then I'd imagine the downsides of heap sort are pretty much universal to all sorts you're likely to use, which makes it more interesting here to me.
At the very least, Clojure's docs seem to say that
sortis stable, which isn't needed here (we know all IDs are unique). You can probably gain performance just by switching to a performant unstable sort, just in general.