Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
lepetitchef
on Jan 8, 2022
|
parent
|
context
|
favorite
| on:
UUIDs are popular, but bad for performance (2019)
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.
isoprophlex
on Jan 8, 2022
[–]
The point is, a uuid contains 128 bits of data, so a varchar(32) is still somewhat excessive
Too
on Jan 8, 2022
|
parent
[–]
Why varchar over char? The length is always the same.
isoprophlex
on Jan 8, 2022
|
root
|
parent
[–]
Yeah, true. My bad. I'm used to calling everything TEXT.
Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: