jatskie / mongo-mysql

Mongo vs Mysql Test Performance in Nodejs

Mongo Mysql Test Performance in Nodejs

Installation

git clone https://github.com/webcaetano/mongo-mysql.git
cd mongo-mysql
npm install
node index

Comparison tests made by this repo

With data size in rows numbers :

10 rows

mysql insert: 1702ms
mysql select: 11ms

mongo insert: 47ms
mongo select: 12ms

100 rows

mysql insert: 8171ms
mysql select: 10ms

mongo insert: 167ms
mongo select: 60ms

1.000 rows

mysql insert: 94813ms (1.58 minutes)
mysql select: 13ms

mongo insert: 1013ms
mongo select: 677ms

10.000 rows

mysql insert: 924695ms (15.41 minutes)
mysql select: 144ms

mongo insert: 9956ms (9.95 seconds)
mongo select: 4539ms (4.539 seconds)

@ivanpopelyshev results :

On SSD virtual server vultr.com

1000: 
mysql insert: 1214ms
mongo insert: 1401ms
mysql select: 9ms
mongo select: 326ms

10000:
mysql insert: 11557ms
mongo insert: 7751ms
mysql select: 30ms
mongo select: 2957ms

ENGINE='MyISAM' for mysql tables:

1000:
mysql insert: 361ms
mongo insert: 938ms
mysql select: 9ms
mongo select: 345ms

10000:
mysql insert: 3394ms
mongo insert: 6985ms
mysql select: 31ms
mongo select: 3080ms