To answer your questions, I do have a M0 cluster, but I have never experienced this kinda of sluggishness some results taking 30 seconds plus.
I was just throwing ideas out there about the driver being the issue, but I have no evidence of that. Maybe these screen shots can shed some light.
I uploaded an image of the last 48 hour or so when the DB started being very slow.
(I cant upload all the images I have as a new user) To me these seem like smaller but it the lag was very high.
I use to use connection incorrectly and exceeded the maximum connections, but since fixing that code I haven’t had issues until now. I don’t have great understand of the metrics and what they should mean for performance, that’s why I mention connections since that’s the only known issue I have had.
I was making more write than before with some new code, but that had been running a week or so and didn’t seem to cause issues. I also started making a React site that might have been using my API to access the DB a little more than I thought. The only reason I not sure that’s the case because even after disabling all that code I continued to have very bad performance.
I hope this can help with coming up with a solution or at least figure out my problem.
last 48 of original DB: