Hello,
Ignition version:8.3.4
Approximate selected time range:8h
Tag history provider: Core Historian
I am working in Ignition Perspective and I am using a Time Series Chart to display historical data for a selected tag.
The chart is bound using Tag History, so it returns a dataset with the history of the selected tag. The time range is configured by the user with:
-
a numeric input field, where the user enters the amount of time
-
a dropdown menu, where the user selects the time unit, for example minutes, hours, days, etc.
The idea is similar to how the time range selection works in the Power Chart.
My main issue is that when the view/chart is opened or time range is changed, the tag history takes a very long time to load. I am trying to understand why the loading time is so long and what the recommended approach would be to improve it.
Is there a way to reduce the loading time of the historical data in a Time Series Chart?
Are there any best practices for using Tag History bindings with Perspective Time Series Charts, especially when the time range is selected dynamically by the user?
Some specific areas I am wondering about are:
-
limiting the amount of returned data
-
using aggregation instead of raw values
-
choosing a suitable interval or sample size
-
avoiding expensive queries when the view first opens
-
whether the Power Chart handles this differently than a manually configured Time Series Chart
Any advice or examples of best practices would be appreciated.
I have also attached screenshots of my current chart settings, Tag History binding configuration, and the input/dropdown components used to define the time range.
If any additional information is needed, such as the Ignition version, database type, tag history provider settings, query mode, sample size, or example tag configuration, I can provide it afterward.
Thank you.
