So we are working on a new large site at work, and we are evaluating different database. To do some comparisons, I downloaded a few million documents from the web (thanks wikipediea ;)) and wrote a little testing suite. The basic take away is wholly crap Mongodb is fast.

So I setup MongoDb, CouchDb, Mysql and Memcached on a local VM. I opened a few hundred thousand documents and inserted them into the various dbs. I indexed the same fields on mysql and mongo, but since memcache and couch don't have indexing, they were just inserted. Next I proceeded to insert 100,000 documents. All I can say is wow. No really wow. Mongo is actually getting faster writes than memcached. That's just plain amazing. Tomorrow I will run the select test against this data.

+------------------------------------------------------------------------+|                            100000 Inserts                              |+------------------------------------------------------------------------+|           | Average   | Median    | Deviation | Lap Total | Total      |+------------------------------------------------------------------------+| MongoDb   | 0.00011   | 7.0E-5    | 0.00012   | 10.70719  | 1712.42024 || MysqlDb   | 0.00083   | 0.00041   | 0.00792   | 82.8752   | 1712.42737 || CouchDb   | 0.0064    | 0.00462   | 0.05921   | 639.94759 | 1712.41974 || Memcached | 0.00279   | 1.0E-5    | 0.00996   | 278.66401 | 1712.39775 |+------------------------------------------------------------------------+