12/3/2023 0 Comments Mysql uuid![]() This technique is based on the fact that a UUID is already a HEX-encoded value. Not to mention that any other table using said UUID as a foreign key will also need 35-bytes.Ī common suggestion for reducing storage size is to persist the value as a VARBINARY(16) instead of a VARCHAR(35). When you consider that the primary key is implicitly stored as the suffix on a secondary index, the storage requirements of a "UUID as String" is multiplied by the number of indexes on the table. If a UUID is a 35-character String, storing said UUID as a String requires 35-bytes (1 byte per character).Īnd, that's just for the column value itself. Part of the index-size issue comes from how the value is stored. This post doesn't tackle all of those issues - I'm here to noodle on just one of them: larger indexes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |