3 ms·

Does anyone know what the difference in performance between a MongoDB that stores its entire data in memory, and a SQL Server (MSSQL, Oracle, Mysql, Postgres, e

Does anyone know what the difference in performance between a MongoDB that stores its entire data in memory, and a SQL Server (MSSQL, Oracle, Mysql, Postgres, etc) that stores its entire data in memory? Is the performance for MongoDB faster than the corresponding SQL server?

mike_esspe 15y ago
Yes, due to absence of SQL parsing and MVCC
- steve8918 15y ago
  Thanks. Would you know if it's a big difference, or just incrementally faster (~10%)?
  - ehthere 15y ago
    It will depend on the type of workload. Some types will be faster, some will be slower. You'd have to run your own tests to see.