Nov 15 2009
MongoDB’s performance as compared to others
I haven’t used PostgreSQL and TokyoTyrant so, can’t say much about them. And technically, I really don’t think that one should compare MySQL which is relational database with document based non-relational databases like: CouchDB and MongoDB.
In my opinion, MongoDB out-performs CouchDB in terms of querying, insertion and ease of usage but CouchDB’s support for MVCC and transaction are quite interesting. One of the crons of MongoDB is it’s data size grow at freaking high rate.
Thoough great to see that, NOSQL (NOt Only SQL) is on full swing.
Download OpenSQL comparison PDF (Don’t forget to read the conclusion though) via HackerNews.

10 Responses to “MongoDB’s performance as compared to others”




Thanks for the writeup. One thing to note about the above benchmark is that the tests were performed using the Ruby driver from a single client *without* the C extension, which greatly improves performance. If the C extension were used (or one of the faster drivers, like Java) you'd see greatly better numbers for MongoDB. The limiting factor in this test was the client, not the MongoDB server itself.
the “Download OpenSQL comparison PDF” link is wrong…
Thanks! Fixed now!
What is unclear (and I'd be happy to see more material) is what type of data was compared.
SQL is going to be a lot faster when (a) you can insert an entire document with one INSERT instead of multiple inserts for denormalized tables, and (b) you can select from one table, instead of using JOINs. Neither the chart above nor the PDF tell me the structure of the data tested, and benchmark-wise, that's where one should hypothetically see the performance difference between document DBs and RDBMS systems.
I, too, would also rather see comparisons between C-level drivers. That will seriously stunt a speed comparison if one is using a C library and the other is using an interpreted language.
can i get the schema that is used for performance testing.
Mark S. is definitely on the right track. If you want to get a professional looking email address, Id recommend buying your name domain name, like or
ajf 6
If its common it might be difficult to get, however, be creative and you can usually find something.
memcache should be more faster than mysql or postgresql in retriving and inserting since it is in mem! This comparision and benchmarks are invalid.
memcache should be more faster than mysql or postgresql in retriving and inserting since it is in mem! This comparision and benchmarks are invalid.
This is fabulous news. Thanks for sharing with us.
Thanks for the great site. good information.