trinodb / grafana-trino

The Trino datasource allows to query and visualize Trino data from within Grafana.
Apache License 2.0
35 stars 10 forks source link

Add caching #209

Open kevinlinxc opened 1 year ago

kevinlinxc commented 1 year ago

My trino queries take about a minute to complete. Every time I load the Trino dashboard, click to a different dashboard and back to the Trino dashboard, the queries are run again, which is really slow and a bad user experience. I think instead, the old data should be cached and displayed while the data is being loaded.

This seems to be an option for other data sources: https://grafana.com/blog/2021/09/02/reduce-costs-and-increase-performance-with-query-caching-in-grafana-cloud/