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

get_my_courses is very slow with lots of courses

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.7
    • 1.9
    • Other
    • None
    • Tested on linux and windows servers and a mysql 4.1.21
    • MySQL
    • MOODLE_17_STABLE
    • MOODLE_19_STABLE

    Description

      the function get_my_courses of lib/datalib.php is very very slow (more than 1 minute) with a database containing a lot of courses (2700 for this exemple).

      Attachments

        1. datalib.diff
          4 kB
        2. datalib.diff
          4 kB
        3. datalib.diff
          4 kB
        4. datalib.diff
          3 kB
        5. datalib.php
          57 kB
        6. datalib.php
          57 kB

        Issue Links

          Activity

            People

              martinlanghoff Martín Langhoff
              mguichar Mikaël Guichard
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              18 Vote for this issue
              Watchers:
              24 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                3/Mar/08