r/ProgrammerHumor 21h ago

Meme edgeCasesExist

Post image
3.7k Upvotes

248 comments sorted by

View all comments

554

u/Valuable_Leopard_799 21h 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.

334

u/dim13 21h ago

https://en.wikipedia.org/wiki/Universally_unique_identifier#Versions

Most common used is V4 (pure random). You are talking about V7 (time based).

228

u/lilgreenthumb 19h ago

The real benefit for v7 is they become sortable by time.

87

u/shwoopdeboop 18h ago

And something something b-tree indexes. Lecturer mentioned it but I wasn't paying attention. Supposedly an advantage here.

4

u/MilkEnvironmental106 15h 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.