Large course (275+ students) makes gradebook unusable

Large course (275+ students) makes gradebook unusable

by Scott Krajewski -
Number of replies: 0

I'm working on a project for middle schools where we have many students (right now 275+) in a single course to access content and take some quizzes.  I'm finding that I can no longer open the gradebook as the UI times out.  If I do get in and I need to add a new grade category when I save the category I'm back in this boat after I click 'save.'

I increased the PHP timeout to 4 minutes (up from 2 minutes).  That gives me more time before I get the timeout error!  After maybe 10 minutes if I re-try in the same session (after MySQL processes have completed) I get in.  Taking 10 minutes per gradebook update/save is too long.

I can see in the MySQL process list that it's going through and doing various processes like

UPDATE mdl_grade_grades

                           SET aggregationstatus = 'used',

                               aggregationweight = 0.021276595744681

                         WHERE itemid = '122' AND userid = '385'

and others after the UI times out.  Once these all complete I can get in in the same session.

We're running Moodle 2.9.2+ (Build: 20151016).

This only became a problem recently as I've added more students to course.

Is there anything I should turn off or can turn off to prevent this recalc from happening all the time?  Are there tricks for large courses?

thanks,

-- Scott