I am setting up a database in MySQL to log some time-series data from a HMI program. I am wondering about the parameters to use to get the pest performance. (I know that a time-series database would be a better option but for the moment I have to use MySQL)

These are the parameters i have used so far:
			vstrSQLQuery = "CREATE TABLE IF NOT EXISTS " & vstrUnitAnalogLogTable(vintUnitNr) & " ("
			vstrSQLQuery = vstrSQLQuery & "Time_Stamp datetime NOT NULL default '0000-00-00 00:00:00',"
			vstrSQLQuery = vstrSQLQuery & " PRIMARY KEY(Time_Stamp)) ENGINE=MyISAM DEFAULT CHARSET=latin1;"
and I have been logging the data as "fload defult NULL".

Any suggestions?