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

Nov 15 2009

MongoDB’s performance as compared to others

Published by 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.


10 responses so far

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

  1. Mike Dirolfon 03 Dec 2009 at 4:06 pm

    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.

  2. Anonon 10 Mar 2010 at 8:29 am

    the “Download OpenSQL comparison PDF” link is wrong…

  3. Prajwal Tuladharon 10 Mar 2010 at 11:08 am

    Thanks! Fixed now!

  4. Matt Butcheron 17 Mar 2010 at 12:18 pm

    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.

  5. raghuon 04 May 2010 at 9:28 am

    can i get the schema that is used for performance testing.

  6. air jordan shoeson 05 Jul 2010 at 3:01 am

    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.

  7. nerknon 17 Aug 2010 at 6:16 am

    memcache should be more faster than mysql or postgresql in retriving and inserting since it is in mem! This comparision and benchmarks are invalid.

  8. nerknon 17 Aug 2010 at 11:16 am

    memcache should be more faster than mysql or postgresql in retriving and inserting since it is in mem! This comparision and benchmarks are invalid.

  9. Modular Homeson 07 Jan 2011 at 6:39 am

    This is fabulous news. Thanks for sharing with us.

  10. Grout Cleaning Montgomeryon 07 Jan 2011 at 9:36 am

    Thanks for the great site. good information.

RSS Feed
Subscribe by email
Follow me @ Twitter