3 ms·
What is the advantage of dropping the smaller integer types? Does it reduce the per-record overhead for example? I have worked with a table that had about 200 m
by dmethvin 16y ago
What is the advantage of dropping the smaller integer types? Does it reduce the per-record overhead for example? I have worked with a table that had about 200 million rows and 4 1-byte tinyint values. If those had to be full 4-byte ints it would require another 2GB to store and reduce the number of records that could fit in memory. Unless there is savings elsewhere?
- jswinghammer 16y agoIn theory you could pack the values in yourself into the larger columns.
- LinuxJedi 16y agoWith InnoDB I believe that it stores the smaller int types as 4 byte anyway. But I am not an expert on this particular section code.
- ldng 16y agoI think the point was to trim down the beast. For that you need tradeoff some features I guess. So small int were cut off. As were triggers, views and stored proc. Most of which is hardly used by target audience, webdev that is.
- LinuxJedi 16y agoThere are plans to bring back at least stored procs very soon. But to do them properly and as a plugin type (so if you don't need them they aren't there)