Good morning, I’m creating reports with many data points. Right now, I’ve been using PowerChart, but it has an aggregation mode and doesn’t offer an “AsStored” option. Anyway, I’ve been asked to create a report that includes all data points with a refresh rate of 1 second, so when users query an entire day or more, it becomes slow. What best practices or additional modules would you recommend for large datasets?
I've attached an example of my report:
If the period is fixed, go with Embr-Charts module and use a Charts.js chart. It's built on HTML canvas which handles significantly more points than the amCharts 4 library that renders using SVG that the IA components are built upon. (note: amCharts 5 actually moved to use canvas)
However, also consider that a screen is limited by pixel count. Rendering, or trying to render, millions of points per tag is not only taxing on performance, it's also physically impossible to do.