2 ms·
UUIDs are sortable, and you can do efficient pagination on them. (The results wouldn't be in any meaningful order, but that's orthogonal.)
by deathanatos 4y ago
UUIDs are sortable, and you can do efficient pagination on them. (The results wouldn't be in any meaningful order, but that's orthogonal.)
- winrid 4y agoYeah 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-right-way https://www.mixmax.com/engineering/api-paging-built-the-righ...