Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-60392

Group assignment grading performance issues

    XMLWordPrintable

    Details

      Description

      We are having performance issues with group assignments grading, view all submissions - view. With normal assignments the loading times for the view all submissions is few seconds, with group assignments this pumps up to 20 to seconds. We looked into this and it seems that the view uses a query that takes 682ms to plan and 0.351ms to execute in PostgreSql, but it runs the query 30 times to create the view -> 30 X 0.6seconds = 18seconds.

      We do realize that part of the problem is the amount of groups & group members in our system
      avle=# select count from mdl_groups; count ------- 30662 (1 row)
      avle=# select count from mdl_groups_members; count -------- 302825 (1 row)
      but this behavior is making the view all - view unusable.

      Our environment is load-balanced 6 nodes (VM) with hardware DB (PostgreSql 9.4).
      I am attaching the Explain Analyze Query into this message.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                juha.h.martikainen@aalto.fi Juha Martikainen
                Participants:
                Component watchers:
                Damyon Wiese, Adrian Greeve, Mihail Geshoski, Peter Dias, Jake Dallimore, Jun Pataleta, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Matteo Scaramuccia, Jake Dallimore, Jun Pataleta
              • Votes:
                4 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: