Hello ,
Database caching :
Adaptive : if I want to cache the query
option 2 : not to cache if I want live Data
Model Persistence :
Metabase will create a materialized view inside my database to make the queries runs fast instead of hitting the database everytime
so what’s the difference between those 2 Database caching and Model Persistence
Thank you
First option does all question queries whether model or just regular. Only caches if slow, then only for a calculated period of time. It’s query specific so includes any filters.
Second option only applies to a model and stores all the data from the model (not related to question queries). It then refreshes on a schedule.
It gets more clever in the pro version.