Question:
In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the best to do so?
- Using one single database with one single Historic table with 25 fields.
- Using one single database with 25 Historics tables with one single field in each table.
- Using 25 databases, each one with a single Historic table with one single field.
Solution:
In this case, the best choices are options 1 or 2, but you must also set up the periodic data discard, so the database file does not reach its limit size. If necessary, you can change the current database to SQL Server or Oracle, which have more storage capacity.
