I have an LMS developed by my team which is being used by 3000 students. The issue is when there is Quiz with more or less 3o MSQ's and 3oo users submit that quiz at the same time, the server doesn't save the answers of all students. And most of the users get 0 marks and got failed. The quiz save script takes just 0.03 seconds to save a quiz.
The same thing happened when 50+ users start uploading their assignments at the last minute of the deadline.
My server is DELL RD730, and the specs are 128GB RAM, 48 Cores Processor. 1G Network card. 250 MB datalink. MySQL is the database the application is using.
I want the perfect and fastest solution to overcome this damn dangerous problem. Please let me know if required any other info. Thanks in advance.
@abidmaqbool Well first you need to find out why the application fails under that load. You can’t fix a problem if you don’t know exactly what the problem is.
So, do some load testing. Find out if the issue is with the number of concurrent requests your web server can handle, or if it’s the number of concurrent database connections being exhausted, or something else…
I really appreciate your suggestions. But somehow my application also uses the SQL server databases to track attendance. But, I didn't find any solution for SQL server integration with Linux centos.