PHP Classes


Recommend this page to a friend!

      PHP Classes blog  >  Developing scalable P...  >  All threads  >  performance  >  (Un) Subscribe thread alerts  
Summary:MongoDb performance vs MySql/MSsql
Author:sody sody
Date:2010-03-02 19:22:14
Update:2010-03-04 07:20:09

  1. performance   Reply   Report abuse  
Picture of sody sody sody sody - 2010-03-02 20:56:13
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.


  2. Re: performance   Reply   Report abuse  
Picture of Cesar D. Rodas 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.

Best regards,