Login   Register  
PHP Classes
elePHPant
Icontem

performance

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      PHP Classes blog  >  Developing scalable P...  >  All threads  >  performance  >  (Un) Subscribe thread alerts  
Subject:performance
Summary:MongoDb performance vs MySql/MSsql
Messages:2
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.

Thanks,
Sody

  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
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,