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

Tasks log: improve class name filter

    XMLWordPrintable

Details

    • MOODLE_39_STABLE
    • MOODLE_401_STABLE
    • MDL-67685_Master
    • Hide

      Generate task log records:

      Using  attached script "create_task_log_records.php": 

      1. Copy the script to admin/cli
      2. Run the script: sudo -u www-data php admin/cli/create_task_log_records.php

      Testing:

      1. Go to "Site Administration > Server > Task logs": https://site}/admin/tasklogs.php
      2. Click "Fitlers" Button, (Right hand side, above the log table)
      3. Type "predict" in the "Class name" search box
      4. The "Auto-completion" should show "Predict models"
      5. Select the class name
      6. Apply filter
      7. The table should show only "Predict models" tasks
      Show
      Generate task log records: Using  attached script "create_task_log_records.php":  Copy the script to admin/cli Run the script: sudo -u www-data php admin/cli/create_task_log_records.php Testing: Go to "Site Administration > Server > Task logs": https:// site}/admin/tasklogs.php Click "Fitlers" Button, (Right hand side, above the log table) Type "predict" in the "Class name" search box The "Auto-completion" should show " Predict models " Select the class name Apply filter The table should show only " Predict models " tasks

    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

              Nguyen Nathan Nguyen
              brendanheywood Brendan Heywood
              Paul Holden Paul Holden
              Shamim Rezaie Shamim Rezaie
              Angelia Dela Cruz Angelia Dela Cruz
              Votes:
              4 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 4 hours, 10 minutes
                  1d 4h 10m

                  Clockify

                    Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.