I’m just switching from a simple docker based node instance with the default sizing to MongoDB Atlas serverless. I have migrated all my data (export then import using Compass), and I have recreated all the indexes as they were on the source database.
However, I am seeing massively slower performance accessing the data from my dev website running locally. I am expecting it to be slower, but not like this. I have a page that runs 4 different aggregate functions across a few different collections. Any fields that need to be are indexed.
On my local Docker instance of MongoDB, the maximum time I am seeing for the page to render is about 500ms. On MongoDB Atlas the same page is taking 45-120 seconds to load!! Looking at my logs from sveltekit, I can see the DB queries genuinley take the time stated above. The Performance Advisor is not suggesting any new indexes or changes.
It shouldn’t be this awful should it?