4 ms·
Wait, MySQL stores the field names with every record? Oracle doesn't do that; Postgres doesn't do that. The documentation I can pull up with five minutes of Goo
by julius_geezer 16y ago
Wait, MySQL stores the field names with every record? Oracle doesn't do that; Postgres doesn't do that. The documentation I can pull up with five minutes of Googling strongly suggests that InnoDB doesn't do that.
So as far as I know MRLCN's savings over MY_RIDICULOUSLY_LONG_COLUMN_NAME gets paid once, in the table header, whether the table has 1 row on 100 million.
- wanderr 16y agoUnless you read the article he linked to before delving into his rant, it's very unclear that he's talking about MongoDB, not MySQL. You are correct that InnoDB and as far as I know all other MySQL engines, does not store field names with every record.