Good evening I have a query, I am creating a sales management system in c # for 3 branches with multiple users and all will be connected at the same time and to the same server, is my query that the data flow is too much saturated? or that depends clearly on the server's capacity ?, what operating system suits me to install windows or linux ?, I was seeing the matter of doker believe that in any of those 3 cases you can have a faster workflow?
In advance I appreciate any comments.
If you use a DBMS such as PostgreSQL, MySQL, MariaDB, etc ... The best thing is that you use Linux, in fact, most servers use Linux.
On the other hand if you use a DBMS like SQLServer running under Windows, you have no choice.
The speed of response of the database will depend on the hardware you have assigned for it. With Linux you exploit all the resources of the PC and you can give the DBMS a lot of resources. I do not know how much the system is used but for what you say I do not think it exceeds 500 concurrent users.
Consider peak activity, for example, Christmas, New Year, holidays, I know, some time where the activity of the users of the system exploits.
Ideally, you create a scenario where load tests, every system has a specific limit with a specific hardware, it is important to know this limit to scale the solution when necessary.
More information