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

Grade Needsupdate with large recordset

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 2.8.3
    • None
    • Gradebook

    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

              Unassigned Unassigned
              modguru Jai Gupta
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: