MongoDB and MySQL in Ruby and PHP
Some time ago, quite interested in developing for MongoDB and spent some benchmarks in comparison with MySQL.
Initially, only Ruby, but when the results astonished (the worse), then in PHP, for comparison.
Maybe it will save someone some time.
Baselines:
System: $ uname-a
Linux pavlin.ik 2.6.31-gentoo-r4 # 1 SMP Sun Nov 1 18:21:31 MSK 2009 i686 Intel ® Core (TM) 2 Duo CPU T5450@1.66GHz GenuineIntel GNU / Linux
MongoDB v. 1.0.1
Gems:
gem mongo (0.16)
gem mongo_ext (0.16)
gem mysql (2.8.1)
Ruby:
ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-linux]
ruby 1.9.1p243 (2009-07-16 revision 24175) [i686-linux]
ruby-enterprise-1.8.7-2009.10
PHP 5.2.11-pl0-gentoo with Suhosin-Patch 0.9.7 (cli)
Source tests are here: http://github.com/latrommi/benchmarking
Actually, the results:
Only one conclusion: it does not mean that MongoDB worse than MySQL, it means that it is not written in a normal, fast driver for Ruby:)
P.S. would be cool if someone would hold similar tests for Python.