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

Tasks log at scale is unusably slow while filtering

    XMLWordPrintable

    Details

    • Affected Branches:
      MOODLE_39_STABLE

      Description

      At default settings on a large site (eg remember 4 weeks or 20) doing a drill down into a class can be slow (many minutes)

      /admin/tasklogs.php?filter=assignfeedback_editpdf%5Ctask%5Cconvert_submissions

       

       This is because it's doing a massive sql like on the output of every task.

      Proposing to:

      1) unlock the session while it is running

      2) add a new filter which is just a direct join in the class (several minutes to, 20ms)

      ie new param:

      /admin/tasklogs.php?class=assignfeedback_editpdf%5Ctask%5Cconvert_submissions

       

       

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              markn Mark Nelson
              Reporter:
              brendanheywood Brendan Heywood
              Participants:
              Component watchers:
              Matteo Scaramuccia, Jake Dallimore, Jun Pataleta, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: