performance

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.

Thanks,
Sody

Hello,

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.

Best regards,