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