News for hackers. Stuff that matters.
Re:Moving Away from UUIDs by winrid on Tuesday November 22, 2022 @05:17AM (#33704137)
Yeah sorry I had a brain fart and was thinking of stable pagination w/ compound sort+filter. It doesn't matter if id is UUID, sigh.

Where date > y or (date eq y and id > x) order by date, id

This can't be completely fulfilled by an index. It'll have to sort/merge somevresults in memory, very CPU expensive.

More examples here https://www.mixmax.com/engineering/api-paging-built-the-righ...

There are no comments on this comment yet.