Currently, the backend data source does not apply any data reduction for large queries. This causes queries made with the "Use Backend" setting set to true to take a long time if the query returns a large amount of data. This also puts unnecessary load on both the archiver and grafana.
I'd like to add this data reducing logic to the backend queries but only for visualization queries, not for alerting queries.
I don't have issue-editing privileges here but I'd flag this as an "enhancement" and assign it to myself if this is something you want to go ahead with, @sasaki77.
Currently, the backend data source does not apply any data reduction for large queries. This causes queries made with the "Use Backend" setting set to true to take a long time if the query returns a large amount of data. This also puts unnecessary load on both the archiver and grafana.
I'd like to add this data reducing logic to the backend queries but only for visualization queries, not for alerting queries.