webcaetano/mongo-mysql

Mongo vs Mysql Test Performance in Nodejs

mongo-mysql's Issues

My results are different

Ok, I ran it on my SSD virtual server on 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

So:

1. how the heck did you get 15 minutes for mysql?
2. why mongo insert is faster when i use mysql myisam?

mongo indexes

MongoDB queries are much faster with indexes (a query on a many millions documents collection with indexes can take less than 1 second but with no indexes many hours or even longer)

So let's compare select queries with indexes as well (MySQL has also indexes).

Could you do it?
Or can I open a PR?

Parameter order for mq-node callbacks is wrong.

(data, err) -> (err, data)

MySQL MyISAM

I think it's better to use MyISAM engine for MySQL to compare with MongoDB because it acts like document database.

The current repo use InnoDB engine as default.