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) Parameter Description - varchar(16) Parameter dbType - varchar(10) Table floatParameter: Parameter ID - small int Datetime - datetime or long Parameter value - float etc .... for the Datetime field .... is it better to use the MySQL built-in DATETIME type, or is it better to save a long (as milliseconds)? The required hard-disk storage by a 'datetime' is the same as for a 'long'? Is there any different in the performance? The queries I will be doing more often are similar to this one: "SELECT datetime, value FROM floatParameter WHERE datetime BETWEEN '2004-10-01 00:00:00' and '2004-10-15 00:00:00'" Discussion is open and suggestions are more than welcome. Jose. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
