NoSQL or SQL database for thousands of rows / items in array every day?

Viewed 34

I would like to keep data about number of views of cca 2.000 videos per day in DB. But let's say I would like to keep the data from the whole year. It would then be 730.000 rows in SQL DB, which I guess is enormous. In NoSQL DB I would then still have e.g. 2.000 objects with some array[365], which is much more fast for processing I guess? What do you think?

1 Answers

Use SQL database like postgres. Postgres is faster for processing because of sql support and indices

730k is nothing btw

Related