When using the sql bridge module/transition group, each tag will create a column in the data table.
If let's say there's one thousand tags, there will be 1001 columns in the same table.
If we need to store the values every 1 second, the number of values in the table will increase rapidly.
Is there a recommended max number of tags to be configured for each table?
It is a DB limitation, typically.
Note that saving data every second this way is way less work for a DB than the equivalent with the tag historian. (One row per second with n+1 columns versus n rows per second with three occupied columns plus some nulls.)
1 Like
thanks for the reply.
Just googled about the database limit.
For postgres: 1600
For SQL Server: 1024
For MySQL: 4096
1 Like
