Tech - NOSQL Tutorial - Part 3 (Performance)
As promised, here are the results of the database shoot out between MongoDB and SQL Server. Before we get into the results, a few things worth noting. The objective of the performance test is a simple use case - search data based on some keys. I have a few self imposed principles to ensure that the test is fair and square - Use the standard configuration for the databases so that it's a fair comparison. Exactly the same data loaded into both the databases, including creating the same kind of indexes too. Exactly the same queries and parameters used for both the databases. Exactly the same client used to execute the queries against both the databases. The same kind of OS and underlying hardware (CPU, RAM etc). There are 3 separate database servers that have been used here. They are - Server 1 - Windows 2008 R2 (64 bit) physical server running MongoDB (64 bit). Server 2 - Windows 2008 R2 (64 bit) virtual server running MongoDB (64 bit). Server 3 - Windows 2008 R2 (