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

Performance improvement in course listings

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.5.2
    • 2.6
    • Course
    • MOODLE_25_STABLE
    • MOODLE_26_STABLE
    • wip-MDL-42020-master
    • Hide

      Test 1.

      1. Create some categories and courses in them, some courses must be hidden
      2. Add categories list to the frontpage (and no other course listings)
      3. Open frontpage (as student), make sure that number of courses in each category is correct - it should not include hidden courses
      4. Purge caches and look at number of courses again
      5. Search courses and make sure that the number of found courses is correct

      Test 2.

      1. Set up frontpage to display list of all courses
      2. Make sure your courses have teachers enrolled in it and they are shown as course contacts
      3. Make sure the course contacts are displayed correctly after purging the caches and after the refresh
      Show
      Test 1. Create some categories and courses in them, some courses must be hidden Add categories list to the frontpage (and no other course listings) Open frontpage (as student), make sure that number of courses in each category is correct - it should not include hidden courses Purge caches and look at number of courses again Search courses and make sure that the number of found courses is correct Test 2. Set up frontpage to display list of all courses Make sure your courses have teachers enrolled in it and they are shown as course contacts Make sure the course contacts are displayed correctly after purging the caches and after the refresh

    Description

      While working on MDL-41942 I've noticed that some code in retrieving list of courses can be faster.

      Examples:

      1. If frontpage shows only categories tree, we call get_courses_count() without calling to get_courses() and this function alone is not efficient.

      2. If the course list is already cached the course contacts are retrieved one-by-one.

      Attachments

        Issue Links

          Discovered while testing

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-42279 PHP warning in setuplib.php

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

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-42277 Warning $PAGE->context was not set in course/management.php

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-42193 Improve coursecat::get_children() so it doesn't do an extra DB query if it has all the categories in cache

          • Major - Major loss of function, incorrect output
          • Open
          is blocked by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-41942 Courses in categories invisible

          • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
          • Closed

          Activity

            People

              marina Marina Glancy
              marina Marina Glancy
              Sam Hemelryk Sam Hemelryk
              Dan Poltawski Dan Poltawski
              Jérôme Mouneyrac Jérôme Mouneyrac
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                18/Nov/13