We recently migrated to Serverless from Dedicated (M30)'s and overall we are seeing considerable performance degradation. I am not sure how anyone can use this with this performance.
Here is some comparison:
2023-11-12T21:12:16.191-06:00 INFO 12336 — [nio-8080-exec-1] : log - result.iterator() 353ms
2023-11-12T16:38:53.716-06:00 INFO 10885 — [nio-8080-exec-1] : log - result.iterator() 7053ms
Thats more than 20x Slow. So I am wondering why would Mongo DB have a product like this.
Please see the screen shot for execution times.
Thank you for the question. Let me reach out to you over direct message as I will need more information about your account and clusters for us to investigate this further.
Thank you for corresponding over DM. After the investigation it was found that your serverless instance was lacking indexes that your dedicated instance did have, which resulted in the performance difference. Thank you for checking and confirming that you don’t see a performance degradation anymore. Please let us know if you have any other questions.