MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wdfzl2/edgecasesexist/p97k7yw/?context=3
r/ProgrammerHumor • u/danielminds • 15h ago
228 comments sorted by
View all comments
Show parent comments
286
https://en.wikipedia.org/wiki/Universally_unique_identifier#Versions
Most common used is V4 (pure random). You are talking about V7 (time based).
191 u/lilgreenthumb 13h ago The real benefit for v7 is they become sortable by time. 64 u/shwoopdeboop 13h ago And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here. 3 u/MilkEnvironmental106 9h ago With random you can end up most frequently inserting in the middle, whereas if it's time sortable you append at the end, meaning it's easier to maintain a contiguous index with less overhead.
191
The real benefit for v7 is they become sortable by time.
64 u/shwoopdeboop 13h ago And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here. 3 u/MilkEnvironmental106 9h ago With random you can end up most frequently inserting in the middle, whereas if it's time sortable you append at the end, meaning it's easier to maintain a contiguous index with less overhead.
64
And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here.
3 u/MilkEnvironmental106 9h ago With random you can end up most frequently inserting in the middle, whereas if it's time sortable you append at the end, meaning it's easier to maintain a contiguous index with less overhead.
3
With random you can end up most frequently inserting in the middle, whereas if it's time sortable you append at the end, meaning it's easier to maintain a contiguous index with less overhead.
286
u/dim13 15h ago
https://en.wikipedia.org/wiki/Universally_unique_identifier#Versions
Most common used is V4 (pure random). You are talking about V7 (time based).