couchdb vs mysql speed

Question

What can you tell about speed of couchdb and mysql databases?

I mean, very simple requests like getting one row (or one document) by unique id and simple requests like getting the 20 ids/rows/documents with the biggest date (of course, using indexes and views etc - don't really know how it works in CouchDB but I'm pretty sure there is something. Please don't send me learn how CouchDB works: I'm going to learn it, but I need a perfomance comparison anyway).

Thanks!

---

As I realized from the links in the first answer, while I have only one server for DB, it's a lot better to use MySQL?

Answer 1

I found this article linked to in another SO question about MySQL vs CouchDB performance, but I don't know if it counts.

Answer 2

Firstly, note that CouchDB is not a relational SQL database like MySQL. I am not sure whether the query you describe can be expressed in CouchDB (but I'm no expert on this).

That being said, here are some links:

• http://metalelf0dev.blogspot.com/2008/09/mysql-couchdb-performance-comparison.html
• http://www.codeweblog.com/couchdb-vs-mysql-insert-performance-test-data-of-the-speed-test/

• When to use CouchDB vs RDBMS

• https://saucelabs.com/blog/goodbye-couchdb