Hi Metabase gurus!
We have a dashboard that has around 50 charts and 35 filters. All the charts are basically the same in structure (column charts with top-N grouping) and show various metrics from one source. Its very useful and is popular among data customers.
The cards themselves are pretty fast. However, filters (which are dropdowns) load around 3-5 seconds, sometimes longer. Is there a way to somehow reconfigure the dashboard or metabase itself to make them fast or pre-load in advance?
Thanks for any advice on this.
Are the dropdowns using linked filters? If so, there is a query run to populate the filters. Maybe you can optimize that query with appropriate indexes?
Hi! Thanks for your input. Filters are not linked to other filters.
Most of the dropdowns are connected to related fields but even those that are filled with custom values are slow.
From my research, most of the overhead comes from the need to validate the filter against all cards and all the other filters connected to the cards.
For example, we have a granularity filter that defines period groupings.
Here is how it performs in various configurations:
same dashboard copied with no cards: 0.28s
same dashboard with cards but no mappings: 0.65s
same dashboard with only granularity mappings: 0.94s
granularity values on the live dashboard (so with all the other filters live): about 5.47s
So the main spike comes not from granularity filter but from overhead coming from other filters that are not related to this one at all.