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

Lesson Overview report runs out of memory for large datasets

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      For Apache, lower PHP memory_limit to something very small, e.g 16MB and restart Apache.

      View a large lesson overview report (e.g 200 users, 5000 attempts) and see the "out of memory" error.

      Apply the patch referenced here and retry the above steps. See the report load successfully .

      Show
      For Apache, lower PHP memory_limit to something very small, e.g 16MB and restart Apache. View a large lesson overview report (e.g 200 users, 5000 attempts) and see the "out of memory" error. Apply the patch referenced here and retry the above steps. See the report load successfully .
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE, MOODLE_28_STABLE
    • Pull Master Branch:

      Description

      If the report has a lot of users/attempts/grades/timers, the report generates an "out of memory" error.

      The report can be optimised to use recordsets for the potentially large datasets retrieved from the database.

        Attachments

          Activity

            People

            Assignee:
            binare Eugene Venter
            Reporter:
            binare Eugene Venter
            Peer reviewer:
            Adrian Greeve
            Integrator:
            Dan Poltawski
            Tester:
            Ankit Agarwal
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              12/Jan/15