Hi,
My server is running Moodle 1.9.2+ (Build 20080813) on RedHat EL 5, it has 4GB of memory.
I have a faculty member who has a gradebook with 5 calculated columns that take into account multiple quizes grades ( Group # 1 - 11 quizes, #2 - 13, #3 - 19, #4 - 12, #5 - 9 ). The calculation for the first quiz group does the following:
=round((401-(400-5))/10,0)+round((401-(400-6))/10,0)+ ... +round((411-(400-5))/10,0)+round((411-(400-6))/10,0)
Where 400 is a constant (7 or 8 depending upon the course) and 401, 402 … 411 are quizzes. The same calculation is setup for each quiz group taking into account that groups specific quizes…
My question is what kind of impact does having calculations like this for multiple quizes have on performance of the gradebook? When he makes changes to the gradebook, the server will take upwards of a minute to return control back to him. I am wondering if when he changes grades if the gradebook has to recalculate all of the grades for all the students?
I haven’t had any other faculty say anything about their gradebooks being slow.
Any comments or questions or requests for more information are welcome.
Thanks,
Chuck