We have repeatedly seen performance issues arising from section signup in large course sites with many sections. One case we have has approx 1400 students and 103 sections.
In this site, a student displaying the Overview page generates 2793 select queries which involve SAKAI_REALM* tables. This is simply unscaleable, especially in circumstances where instructors advertise that section signup will begin at a particular time, and hundreds of students login simultaneously and refresh the overview page until section signup is enabled.
|Add thread-local caching to SectionManager||CLOSED||Unassigned|
|Add authz methods to query multiple groups efficiently||CLOSED|