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.