Metabase with mongodb is too slow

Get Help
1

I am running metabase in localhost using mongodb as datasource.
Created a native query with lookup processing around 5 collection data.

The query takes more than 2 minutes to show the results with
2000 records in the metabase ui.

It takes around 15 to 20minutes to export the result
to csv which has around 30k records.

Is this normal or is there anything can be done to improve the speed.

I am using remote mongodb atlas db. Running metabase locally in my system.
These collections have 30k to 60k records.

Please let me know if you need any other information.

Thanks

2

Please post sizing of the machines. Do you have any index? How much do those queries take without Metabase (via the mongo cli)

3

I have ran a sample lookup in both metabase and mongodb compass. They both take same time approximately. So I believe metabase may not be causing slowness of the report generation.

Thanks for your response.