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

Adding indexes in h5p database table (backport of MDL-71129)

XMLWordPrintable

    • MOODLE_311_STABLE, MOODLE_400_STABLE
    • MOODLE_311_STABLE, MOODLE_400_STABLE
    • Hide

      Test with a new Moodle site and a site upgraded from 3.10 for 3.11 patch, and from 3.11 for 4.0 patch.

      1. As an admin go to Development > XMLDB editor
      2. Click on Load link at 'lib/db' row
      3. Click on Doc link at 'lib/db' row
      4. Go to 'H5P' section (Stores H5P content information)
      5. Confirm a index called 'pathnamehash_idx' exists, not unique and with 'pathnamehash' as Field(s)

      Show
      Test with a new Moodle site and a site upgraded from 3.10 for 3.11 patch, and from 3.11 for 4.0 patch. As an admin go to Development > XMLDB editor Click on Load link at 'lib/db' row Click on Doc link at 'lib/db' row Go to 'H5P' section (Stores H5P content information) Confirm  a index called 'pathnamehash_idx' exists, not unique and with 'pathnamehash' as Field(s)
    • 1
    • HQ 2-week review sprint

      A performance improvement for H5P has been integrated on MDL-71129

      This is a request to backport this improvement also to stable versions, because performance improvements are also helpful for all stables and this change doesn't seem risky.

        1. image-2022-08-25-12-12-59-969.png
          10 kB
          Amaia Anabitarte
        2. MDL-75766_v311.png
          83 kB
          Angelia Dela Cruz
        3. MDL-75766_v400.png
          83 kB
          Angelia Dela Cruz

            amaia Amaia Anabitarte
            amaia Amaia Anabitarte
            Carlos Escobedo Carlos Escobedo
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            2 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours
                3h

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.