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

get_my_courses is very slow with lots of courses

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.9
    • Component/s: Other
    • Labels:
      None
    • Environment:
      Tested on linux and windows servers and a mysql 4.1.21
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_17_STABLE
    • Fixed Branches:
      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

              • Votes:
                18 Vote for this issue
                Watchers:
                24 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  3/Mar/08