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

Grade Needsupdate with large recordset

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.8.3
    • Fix Version/s: None
    • Component/s: Gradebook
    • Labels:

      Description

      We noticed that Grade needsupdate code in Latest 2.8 fails with large recordset. We have a client which has a single course having 2m records. All other courses went fine with needsupdate code but that one course stuck.

      Problem is that for various reasons (timeouts, memory etc) it is not practical to execute this amount of processing on browser.

      Workaround: We created a cli script and executed it via shell.
      Solution: It would be better to push similar code in cron.

        Attachments

        1. CPU Usage.png
          CPU Usage.png
          34 kB
        2. regrade_all.php
          0.5 kB
        3. regradecli.php
          0.3 kB

          Issue Links

            Activity

              People

              • Votes:
                3 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: