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.

            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.