Search code examples
sqldatabasenosqlspace

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

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?

Solution

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

    730k is nothing btw