Best database engine for huge datasets

Question

I do datamining and my work involves loading and unloading +1GB database dump files into MySQL. I am wondering is there any other free database engine that works better than MySQL on huge databases? is PostgreSQL better in terms of performance?

I only use basic SQL commands so speed is the only factor for me to choose a database

Answer 1

It is unlikely that substituting a different database engine will provide a huge increase in performance. The slow down you mention is more likely to be related to your schema design and data access patterns. Maybe you could provide some more information about that? For example, is the data stored as a time series? Are records written once sequentially or inserted / updated / deleted arbitrarily?

Answer 2

As long as you drop indexes before inserting huge data, should not be much difference between those two.