We have 20 furnaces and 10 presses, each has between 1 and 10 datapoints that are recorded.
How should these data points be saved in a SQL database?
Using transaction groups, all the data would be stored in one table with each data point being a column.
Would it be better to separate each furnace into its own table?
Or should I use the SQL Historian tag option?
Data is collected once per minute on the furnaces and every 5 seconds on the presses.