I'm new to indusoft and I have a trending question: when do you use the propietary format, and when do you use a database? We tried logging our trend sheets to a database, but everything was logged in the same file. Because we have quite a lot of data, we would like to have a file every day. Therefore, we changed to the propietary format because then automatically a file is created every day and per trend sheet. Is this possible for database too? Perhaps the database solution is more interesting for us concerning search options.
I've always thought that one of the advantages of logging to a database is that you don't end up with a new 'file' every day? Using a database allows for very flexible reporting by making use of timestamps to analyse or present arbitrary periods of operation.
That is, presentation from the database can be for any time period ... so a 'file' per day shouldn't really be a requirement. I have only used the proprietary format for trending, but save other production information in remote SQL databases using the DB functions.
In general, I would advise using the proprietary format for trend logging unless you need to do the kind of analysis on your data that is provided through SQL.
I've always thought that one of the advantages of logging to a database is that you don't end up with a new 'file' every day? Using a database allows for very flexible reporting by making use of timestamps to analyse or present arbitrary periods of operation.
That is, presentation from the database can be for any time period ... so a 'file' per day shouldn't really be a requirement. I have only used the proprietary format for trending, but save other production information in remote SQL databases using the DB functions.
In general, I would advise using the proprietary format for trend logging unless you need to do the kind of analysis on your data that is provided through SQL.
