Question for database setup

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)?

Hi @xuheng925
You should do such operation on your database, alternatively you could use caching:
https://www.metabase.com/docs/latest/administration-guide/14-caching.html

Great thank you!