Comparison of the query performance for each database

[adrianhall]

Hey folks,

I'm currently expanding the test suite to include more databases and specific controller tests. One of the things I have now is a query-only set of 312 queries per database. Since this exercises standard queries, it's interesting to compare database query performance. For those wondering, databases that are cloud based are operating in the same region and with the same virtual hardware.

Database	Execution Time
In Memory	8.4 seconds
LiteDb	20.6 seconds
Cosmos	2.6 minutes
Azure SQL	3.1 minutes
PostgreSQL	5.7 minutes
MySQL	9.8 minutes

All the models are set up the same way, queries are executed in series. InMemory and LiteDb are local stores whereas the others are cloud-based stores. When run in parallel, the differences are much less drastic but the ordering is the same.