Mongo vs Mysql Test Performance in Nodejs
Clone or download
Latest commit 50db18c Nov 5, 2015
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.editorconfig init Sep 16, 2015
.gitignore init Sep 16, 2015
README.md Update README.md Nov 5, 2015
index.js init Sep 16, 2015
mongo.js init Sep 16, 2015
mysql.js init Sep 16, 2015
package.json remove mysql Sep 16, 2015

README.md

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