Question:
What is the maximum amount of fields a Historic can have in an E3 application?
Solution:
It will depend on your database. SQL Server accepts up to 1024 columns per table; Oracle, 1000; and Access, only 255. However, bear in mind that these numbers are cut in half in E3 because of Quality field. So, in E3, the maximum amount of fields a historic can have is:
- SQL Server = E3TimeStamp + 511 fields
- Oracle = E3TimeStamp + 499 fields
- Access = E3TimeStamp + 127 fields
