News for hackers. Stuff that matters.
Re:UUIDs are popular, but bad for performance (2019) by lepetitchef on Saturday January 08, 2022 @10:15AM (#29852399)
Fun improvement from my project a long time ago, uuid has 36 char and to save space, we created a shorten version by removing all the dash character in uuid. The result is 4 char could be removed, the field in MySQL table only needs 32 char.
Re:UUIDs are popular, but bad for performance (2019) by isoprophlex on Saturday January 08, 2022 @10:35AM (#29852596)
The point is, a uuid contains 128 bits of data, so a varchar(32) is still somewhat excessive
Re:UUIDs are popular, but bad for performance (2019) by Too on Saturday January 08, 2022 @10:53AM (#29852788)
Why varchar over char? The length is always the same.
Re:UUIDs are popular, but bad for performance (2019) by isoprophlex on Saturday January 08, 2022 @11:05AM (#29852913)
Yeah, true. My bad. I'm used to calling everything TEXT.