We have several dashboards which are basically static. They are supplied with data that is refreshed daily and don’t change all day.
However, the underlying queries are slow and with several users, they frequently cause a backlog of queries and metabase to become unusable.
The solution we want to explore is to run a script clearing the cache - like so:
No way to clear cache ? (or TRUNCATE TABLE QUERY_CACHE ?) -
and then refresh the relevant dashboards using the API.
we would then want the dashboard to cache all day. However, my concern is that setting the caching threshold very low (e.g. 0 seconds) and TTL to make everything last all day - would cause every query to be cached. And I don’t know what effect that would have on the application.
Has anyone else tried this method? Has anyone else had this issue? how have you gone about solving it?