The speed of reading many records is faster in MongoDB or SQLSERVER?

I use SQLSERVER and because of the high speed of Mongo DB, I want to change the program’s database.
But with the test I did, I found out that the speed of MongoDB in reading many records is not high and requires a lot of time and uses a lot of RAM memory.
Do you agree?

Your question is way to generic.

If your tests really reflects your use-cases and your tests indicates that one is better than the other, then use the better one. We cannot make this decision for you.

Any server that requires performance should run on dedicated hardware/VM and should use all the resources available. If it does not, then your system is over provisioned or the server is not optimized. RAM is way faster than disk and everything that fits in RAM should be in RAM.

1 Like