I need to decide which database server to use for my next project, but the simple solution to use MySQL, like almost all the projects that I have done, is more complicated because I expect so many records.
The database will contain a list of users, some other irrelevant tables and the last, some data collected by the user. Let's say if I have 6,000 users answering a quiz about each other. Simple math shows that from these users, if each of them completes the quiz about everyone (and in my project, which is 99% sure that this will happen), I get 35.99 million records (they will exclude themselves in this particular situation 6000 * 5999). Unfortunately, 6000 may be a small number, a real, growing day by day.
What to choose? MySQL, and maybe if everything goes well, and the project will expand in the cluster? PostgreSQL, MSSQL? Oracle?
I read about all of them, each of them has pros and cons, but still do not know what to choose. The advantage of MySQL and PostgreSQL is, of course, the starting price of $ 0, which is pretty good with a regular self-funded launch.
Any opinions, tips? If you have encountered this situation in your development experience, I would like to hear from you.
source
share