|
Roshan Sumbaly wrote:
The software uses MySQL
backend and Apache web server. We had a mock test and realised that the
minute the number of students logging in increased to beyond 30, the
computer became slow and finally couldn't withstand it. Beyond 30
students
sitting at once the PHP pages failed to load and students couldn't log
in.
Luckily this was the mock exam!!
30? What on a ZX81? - Thats crazy you've either got a broken
apache/mysql/php config (probably mySQL) or some hideously bad programming.
You need to isolate your problem even with load balancing from those
figures you'd need 15 servers!!
Its probably a fairly easy fix, just do some basic timing of the pages
i.e. time stamp at the top and at the bottom and find the problem, Have
you got enough memory assigned to MySQL and has it got indexes
run a query plan etc....
Clustering is generally for a larger number of users... IMHO anyway.
Regards,
Malcolm.
|
