Generating plots takes a long time with 1s log interval. downsampling?
I have a mangoES with mango 2.7.4 It has the tiny-TSDB and H2 databases. It has 4 modbus TCP data sources with a total of 75 points. The modbus TCP data sources are set to update with 3s period, the data points are set to log at 1s intervals because I previously had the data sources set to update with 1s period as well, but there were overlapping polls so I had to increase the data source read period.
Each point is generating 3600 samples an hour, 86400 samples a day, as evidenced by the record count above the plots in reports.
It takes a long time to generate any plots in the watchlist or graphical views. A report with 8 points takes about 30s to run.
It appears that no downsampling is performed on the data before passing it to JFreeChart so all 86400 samples for each point would be retrieved from the database and plotted even if the plot is only 400 pixels wide.
What would it take to speed up the plotting? Should I file a github issue?
terrypacker last edited by
We are working to replace the JFreeCharts with the new AmCharts found in the DataPointDetails module. The new charts use new methodology to generate the data which include 'rollups'. Rollups allow you to request data placed into bins. So for example you could request the past 24hrs worth of data averaged at 10 minute intervals.