Hello,
If you aim for for absolute control over the storage (the fileystem
nature is the limit), and speed, do not use an SQL system. Of course,
you would have to face all the trouble of writing your own
mini-engine/subsystem for the job. It all comes down to what your
needs are and how much time
I need to store huge data series using MySQL with InnoDB as storage
engine. The data type of the parameters can be double, float, int,
smallint, mediumint, tinyint So, I've thought to store them in
the following way:
Table Parameter:
Parameter ID - small int
Parameter Name - varchar(8)
Parame