Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm currently looking for a database engine than can easily handle queries on multiple collections/tables (at least 5) with aprox 10M entries each.

Any advice on what to use?

share|improve this question

closed as primarily opinion-based by Mat, Paul White, dezso, Mark Storey-Smith, Kin Aug 23 '13 at 14:29

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

Any modern DBMS can handle that (if properly indexed). 10 Million rows is far from being considered "very large" nowadays. –  a_horse_with_no_name Aug 23 '13 at 10:59
can you name one, the best you know? I know than they can handle the datasets, by would the joins be fast enough? Less than 500ms –  Alexandru Rada Aug 23 '13 at 11:00
The "best" is always very subjective. In the open source world I personally think there is only one choice: PostgreSQL because it is indeed much more advanced than e.g. MySQL with all its limits and quirks. From the commercial ones, it doesn't really matter which one you use - take the one you are familiar with. –  a_horse_with_no_name Aug 23 '13 at 11:02