blob vs. many columns

[David Picard]

I have to store data sets of FLOAT, whose size may vary from about 20 to 300 values. I use InnoDB as the storage engine.

I am thinking of 2 options :
1/ use a BLOB
2/ create 300 columns in a table, and set unused values to NULL

Option 1 will optimize the storage size, but read/writes may be more complicated.
Option 2 will be easier to read/write, but there will be many NULL values. How about NULL values storage ?



Edited 1 time(s). Last edit at 07/04/2012 05:46AM by David Picard.