Report rendering too slow when we use mongodb storage
When we try to render a report using file system storage, the report generates quickly within 2-3 seconds. But when we try the mongodb atlas storage, the report generation takes a significant amount of time like 45 seconds to generate the same report.
Why does it take so much of time? Is it something to do with mongodb atlas?
Do you use a shared atlas instance or a dedicated replica set? What if you try a local Mongo instance, the performance is ok? How many entities do you have? You can look into atlas profiler what query is slow.