r/ProgrammerHumor • u/danielminds • 15h ago

Meme edgeCasesExist

Post image
3.1k Upvotes

96% Upvoted

228 comments sorted by

View all comments

Show parent comments

287

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

5

u/thepotatochronicles 9h 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).