-
Improvement
-
Resolution: Fixed
-
Minor
-
3.10.2, 4.1
-
MOODLE_310_STABLE, MOODLE_401_STABLE
-
MOODLE_401_STABLE
-
MDL-71129-master -
Test with a new Moodle site and a site upgraded from 4.0
- 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)
Test with a new Moodle site and a site upgraded from 4.0 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)
-
HQ Sprint 0.3 Database
In order to optimizing our database performance, we have found the SQL Query called in the function get_content_from_pluginfile_url in h5p-plugin:
SELECT * FROM `mdl_h5p` WHERE `pathnamehash` = ?
This query took almost 1minute for approximately 6 execution. We want to put an index on the field pathnamehash. Is that a good solution? or does anyone have any idea?
- will help resolve
-
-
- Closed
-
