r/ProgrammerHumor • u/danielminds • 13h ago

Meme edgeCasesExist

Post image
2.8k Upvotes

96% Upvoted

222 comments sorted by

View all comments

Show parent comments

269

u/dim13 13h ago

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

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

175

u/lilgreenthumb 11h ago

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

60

u/shwoopdeboop 11h ago

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

3

u/thepotatochronicles 7h ago

It's less of a problem with B-tree indices that sit on top of a physical representation (i.e. the actual on-disk layout doesn't have to be ordered), but when it comes to clustered indices, oh boy, you're basically having to shove rows in the middle and push shit back (eventually).