We are a SMB and use MongoDB as our application's database. The raw data we need to create Metabase questions/dashboard are currently stored in multiple tables and the it takes Metabase 4~5 minutes to display the report. To minimize the time would you recommend us to create a table that aggregates the raw data from the multiple source tables in our database end (as opposed to having Metabase to do the join opertion)?
You should do such operation on your database, alternatively you could use caching:
Great thank you!