4 ms·
You'd be insane to put the primary key in a varchar. Mysql is much faster with static width tables. Your main user table should be static width for all the fiel
by bitJericho 9y ago
You'd be insane to put the primary key in a varchar. Mysql is much faster with static width tables. Your main user table should be static width for all the fields.
- cwyers 9y agoAs opposed to the insanity of storing UUIDs as strings at all? Once you start going into the rabbit hole, you better be prepared to go all the way down.
- bitJericho 9y agoNo doubt. You can store them as INTs! Tho it does get a little hairy dealing with the conversion with MySQL.
- paulryanrogers 9y agoIs this true for all storage engines?
- morgo 9y agoIt is not true for innodb (default). See my other comments in this thread.