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

Move temp table usage to create_temp_table and ensure temp tables defined with xml_table rather than install.xml

    XMLWordPrintable

Details

    • MOODLE_25_STABLE
    • MOODLE_26_STABLE
    • MDL-40103_temptable
    • Hide

      1. Run daily stats with records to ensure the table is operating correctly. (The more complex the statistics, the more thorough the coverage)

      2. Backup a subject and restore it into a new course. Complex subjects will exercise the table structure more.

      Show
      1. Run daily stats with records to ensure the table is operating correctly. (The more complex the statistics, the more thorough the coverage) 2. Backup a subject and restore it into a new course. Complex subjects will exercise the table structure more.

    Description

      After discussion at https://moodle.org/mod/forum/discuss.php?d=230161 and the benefit of a simplified setup to MDL-39725.

      All temporary tables need to be changed to use the method (3) described in the forum post.

      Attachments

        Issue Links

          will help resolve

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-39725 PostgreSQL performance can be poor with large temp tables

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

          Activity

            People

              mr-russ Russell Smith
              mr-russ Russell Smith
              Petr Skoda Petr Skoda
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Damyon Wiese Damyon Wiese
              Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                18/Nov/13