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

  • http://www.dirolf.com Mike Dirolf

    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.

  • Anon

    the “Download OpenSQL comparison PDF” link is wrong…

    • http://prajwal-tuladhar.net.np/ Prajwal Tuladhar

      Thanks! Fixed now!

  • http://technosophos.com/ Matt Butcher

    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.

  • raghu

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

  • http://www.discount-air-jordan.com air jordan shoes

    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.

  • http://nerkn.mornehir.com nerkn

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

  • http://nerkn.mornehir.com nerkn

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

  • http://www.modularhomesnetwork.com/ Modular Homes

    This is fabulous news. Thanks for sharing with us.

  • http://www.tri-statefloorservice.com/1901919059.tile-grout-cleaning-service.grout-cleaning.html Grout Cleaning Montgomery

    Thanks for the great site. good information.

RSS Feed
Subscribe by email
Follow me @ Twitter