Hello. I am starting to develop a project and am afraid of miscalculation. Many data and users are planned (there will be no connections between users). Which database to choose to store data. If I used any sql database, then the number of added records in the tables in one day can exceed tens and hundreds of thousands. Or is it not scary and can Sql be used?

  • thousands of entries per day will be due to the large number of users. And you counted only the records in the database, and reading from the database? - just
  • Tell me more - maybe it will be clear. But sometimes it is useful to separate the bases. For example, it is good to deal with any statistics / counters in MongoDB - it can cope well with this, and if it falls ... it's not scary. But the main base can be unloaded heavily. - KoVadim
  • one
    You are not the first to ask this question, including in this forum: hashcode.ru/search/?q=sql+nosql&t=question - a_gura

1 answer 1

If it is normal to design, then of course not scary. nosql solutions are not always faster or better. 100k records per day is only 11 requests per second.

I recommend to sit down with a leaf and count everything. And in three versions - pessimistic, average and optimistic. Then the questions disappear.

Take any base - MySql (or MariaDB) or PostgreSQL and try.

But I think that there are unlikely to be thousands of records a day, unless they are too smart with the design.