I’m self-hosting Metabase and embedding a Dashboard on a website.
I’ve opted for a single Dashboard with multiple tabs to organise data.
However, as I’m building on the questions, I’m noticing how slow everything is becoming. I enabled Adaptive Caching, but this hasn’t been a s much of a help as I thought it would be.
Now I’m wondering if my structure is the problem - I assumed each tab would only load the questions for that tab, once viewed. Is that correct? Or are all questions across the Dashboard loading upon Dashboard view?
If so, perhaps I should be adding a tab view in my website with each tab loading a different Dashboard embed?
Thanks!
The questions on a tab are only loaded when the tab is selected (it wasn’t always like that though).
You might need to tune caching to be used for shorter queries and to last longer.
Alternatively, use models and cache the models.
Also, how many questions do you have per tab? Fewer is better!
Thanks for the reply, very helpful. Main point for me is confirmation about tabs, and that was the answer I was hoping for 
I’m aware of the other improvements, so will look into them. I can at least consider each tab, so I’m focusing on which tabs are the slowest and what the question types and data structure may be.
I’m using Models but haven’t enabled Model caching (so far I’ve avoided any features that write to our connected DB).