Good Morning,
We want to know it iss possible to increase timeframe records of the dataavg table, on the configuration of the dataminer - central database we only had three options:
Offload: All timefrane records (5 minutes, 60 minutes)
Only short timeframe records (5 minutes)
Only long timeframe records (60 minutes)
For example if we can execute the offload of the table every 15 mins, 30 mins or the time that we want.
Regards
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 17th July 2023
What will be the funcionality of this options (on yellow).
Brent Alleweireldt [SLC] Posted new comment 16th February 2022
Hey Javier,
The Offload Once every minutes. Decides how often these values are generated. It is meant to be able to collect the data without being tied to when the data is actually pushed to the central DataBase. As an example you set the general offload time to 5 minutes and the trend data offload to 7 minutes (starting at 12:00:00). then the following cycle will happen
12:05- Offload timer fires, no trend data has been generated so it is not uploaded
12:07-trend data has been generated but not uploaded
12:10-Data is uploaded (included the 12:07 trend data)
12:14-new set of trend data is generate but not uploaded.
12:15-Data is uploaded to the db
….
The second setting you highlighted relates to average trending. You can choose there which average trendpoints you want.
(short 5-minutes) are gnerated by the system every 5 minutes
(long 60-minutes) are generated once every hour.
Just like the previous example this is when the data is generated, not when it is uploaded. So to reuse the example, only offloading the long timeframes, with an offload rate of 5 minutes will create the following cycle
12:00:00-trend data is generated and uploaded
12:05:00-Data is pushed to the central DB but no new avg trending is present
12:10:00-Data is pushed to the central DB but no new avg trending is present
12:15:00-Data is pushed to the central DB but no new avg trending is present
….
13:00:00-trend data is generated and uploaded
I hope this clarifies the questions a bit