As part of learning new tools for testing, I took the mongoDB database performance and comparing the results of a MySQL database, both in MyISAM and innoDB tables.
As a test platform, I used only the local computer with 4 GB of RAM, i3 (2.4 GHz). The data source was a table of 217 thousand of records.
MySQL (MyISAM) – 5.1.49
MySQL (InnoDB) – 5.1.49
MongoDB – 2.0.2
PHP – 5.3.6
All times are in seconds, and each query is executed in a loop 10 times and the result presented is the average of these 10 performances.
|MySQL (MyISAM)||MySQL (innoDB)||mongoDB|
|WHERE field = ?||3.631||21.911||0.016|
|WHERE field zLIKE ‘x%’||3.755||19.562||0.040|
The results speak for themselves – mongoDB is perfect for large databases, where the advantage over MySQL is the most visible.