Prajwal Tuladhar’s Blog
 
programming, life and some random thoughts

Nov 15 2009

MongoDB’s performance as compared to others

Published by Prajwal Tuladhar at 8:19 pm under MongoDB

Click to view the full size

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.


  • memcache should be more faster than mysql or postgresql in retriving and inserting since it is in mem! This comparision and benchmarks are invalid.
  • raghu
    can i get the schema that is used for performance testing.
  • 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.
  • Anon
    the "Download OpenSQL comparison PDF" link is wrong...
  • Thanks! Fixed now!
  • 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.
blog comments powered by Disqus

RSS Feed
Subscribe by email
Follow me @ Twitter