News for hackers. Stuff that matters.
Re:Bye Sequence, Hello UUIDv7 by paulddraper on Monday October 02, 2023 @01:31AM (#37734332)
It depends if you have a request covers a lot of sequential data, or if you have a lot of requests of sequential data.
Re:Bye Sequence, Hello UUIDv7 by stepanhruda on Monday October 02, 2023 @09:20AM (#37737700)
Correct, it speeds up latency in best case scenario, and falls over in worst case scenario. Randomly sharded keys give a more consistent performance.
Re:Bye Sequence, Hello UUIDv7 by chacham15 on Monday October 02, 2023 @06:42PM (#37745447)
You're painting with way too broad of a brush. It is not always better and not always worse. E.g. "give me a list of users who made two posts where both posts were created within 1 second of each other" This query would likely blow up on a system which has all the data completely randomly sharded (because you'd have to aggregate all the data centrally, unless you had a complicated shuffle setup (which most dbs dont)) whereas would work fine on a system which has posts sharded by time.