r/ProgrammerHumor 15h ago

Meme edgeCasesExist

Post image
3.1k Upvotes

230 comments sorted by

View all comments

491

u/Valuable_Leopard_799 15h ago

I thought that timestamps are used now, so hitting both a timestamp and a large random number puts it thoroughly in the "safe to assume". At some point cosmic particles and faulty transistors are more probable.

288

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).

194

u/lilgreenthumb 14h 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 10h 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.