|I went over the article, and its a different but interesting way to use DBs, but i wonder if there has been done any benchmarks for performance versus other db servers like mysql or mssql.|
Cesar D. Rodas
|2010-03-04 07:20:09 - In reply to message 1 from sody sody|
That's a really good question, and I don't have an answer. I've been googling in the past for this I didn't find any answer. If you have an idea about how to do this, I'll be glad to help.
I'm using MongoDB for a simple reason, its simplicity and speed. Databases in general are slow, PHP needs to wait for them to respond most of the time (even key-value DB are slow). They are slow for several reasons, network traffic, IO operations, SQL parsing and compiling, and so forth.
Database are slow, but I can't live without them, so I chose a document-oriented database because I can organize my data in such way that I talk to my database as less as possible. I can even organize my data in such a way that I can simulate inner join operations with just two queries (for two SQL-tables).
And finally I chose MongoDB over it's alternatives because it had copied the best things from the SQL world (indexes, shard keys, dynamic queries) with the speed/efficiency of a key-value DB. Also, it has a very intuitive API, I didn't need to learn anything new.