lundi 17 août 2015

SQLite vs. MySQL vs Postgres - which has the best benchmark performance for a single table database?

I'm trying to do a research project on the stock market that involves the history of 1000 stocks from the last 15 years. I have a CSV with 1000 stocks totaling 12 million rows.

Which of these would be the speediest for my purposes? SQLite MySQL Postgres

I only need one table in my database, but I will have to do all sorts of complicated queries and sub-queries - such as comparing stock prices from one week to the next and such. I will have an index on the ticket name and the closing date.

Not looking for opinions but actual benchmarks - this is really NOT a subjective question at all.

Aucun commentaire:

Enregistrer un commentaire