Metabase Caching Setting

Get Help
#1

Hi Metabase Team,
I have noticed that some of my questions take more than 50 seconds to run due to the live nature of the data. This can be frustrating and time-consuming, especially when I need to run multiple queries. After researching, I realized that caching could be a solution to speed up the queries that take longer than a certain threshold.

I am reaching out to ask if you could guide me on how to enable caching for questions that take more than 10 seconds and refresh the cache every 24 hours? I believe this could significantly improve the performance of my queries, and make my work more efficient.

I appreciate any guidance you can provide on this matter

cache-size
cache-size783×586 42.5 KB

r, and once again, thank you for creating such a powerful and useful tool.

#2

Hi! Cache is not refreshed automatically. Those configurations are fine for what you want to achiever

#3

Cache is not refreshed automatically so o have to run the question manual

#4

i want to update it every 24 hours and 100 ttl it's per second

#5

yes, you will need to refresh the cache manually or programatically (running those questions via the API)

#6

How I do it programmatically

#7

Build a script with the language of your choice that calls the Metabase APIs to run the questions