node-red-contrib-opcua icon indicating copy to clipboard operation
node-red-contrib-opcua copied to clipboard

Published 20 hours ago • verified publisher icon mikakaraila

Question: Configuration of Historical Access

Open AndreSchm opened this issue 2 years ago • 3 comments

Is there a way to configure the following two properties in context of Historical Access:

  1. Storage of historical data As far as I understood the default memory space for the historical data is the main memory. Is there a way to set an other memory type like file system or a database?

  2. Maximum data points per node in HA The maximum amount of data points per node is capped at 1000. Is there a way to increase this threshold? Reading the docs I found the MaxReturnDataValues property. Is this implemented and configurable?

Thank you very much in advance.

AndreSchm avatar Jun 22 '22 14:06 AndreSchm

  1. Not at the moment, I didn´t put any options. There are some ways to add this feature. I will make small study how to add this. Any proposal what TSDB or database you would like to use?
  2. See above, I could add options then user can define amount of data points.

I have implemented this for our product. It actually defines own class and uses it to make callbacks for the historian DB.

mikakaraila avatar Jun 22 '22 17:06 mikakaraila

I would think of influxdb, postgres (maybe timescale) or MS sql server but I'm not sure, whether they are applicable for this purpose.

AndreSchm avatar Jun 23 '22 13:06 AndreSchm

Any news on implementing an option to increase buffer size and/or target an external database for persistent storage?

Eichi87 avatar May 11 '24 11:05 Eichi87