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

Reduce the performance impact of checking if a course has overview files

    XMLWordPrintable

Details

    Description

      overviewfiles is not a mdl_course table field so we need to query mdl_files to see if that filearea has any files. DB reads to mdl_file are not cheap and we should avoid it. We noticed this performance regression when MDL-63445 got integrated as we have 1 extra db read despite not having course overview files. A possible option is a cache definition, another one (worst I guess) a new field in mdl_course and there may be others. Adding a solution for this would also help us reduce the number of db reads we are currently doing to display other course overview images.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dmonllao David Monllaó
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Raquel Ortega, Sara Arjona (@sarjona), Matteo Scaramuccia, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: