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

Speed up grade_item::get_final() by using better SQL instead of a loop

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.2.1
    • Fix Version/s: STABLE backlog
    • Component/s: Gradebook
    • Labels:
    • Database:
      Any
    • Affected Branches:
      MOODLE_22_STABLE

      Description

      grade_item::get_final() retrieves a bunch of grade_grades then uses an array to get them into an array keyed on user ID. Replace this with smarter SQL to avoid the loop.

        Attachments

          Issue Links

          has a non-specific relationship to

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-30999 grade API, check and update DocBlock

          • Minor - Minor loss of function where workaround is possible
          • Closed

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              andyjdavis Andrew Davis
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: