High performance querying - Suggestions please
- by Alex Takitani
Supposing that I have millions of user profiles, with hundreds of fields (name, gender, preferred pet and so on...).
You want to make searches on profiles.
Ex.:All profiles that has age between x and y, loves butterflies, hates chocolate....
With database would you choose?
Suppose that You have a Facebook like load.
Speed is a must.
Open Source preferred.
I've read a lot about Cassandra, HBase, Mongo, Mysql... I just can't decide.....