Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-23754 Performance improvements META
  3. MDL-24695

Add index to user_info_data table

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 1.9.9, 2.0.1
    • Fix Version/s: None
    • Component/s: Performance
    • Database:
      Any
    • Difficulty:
      Easy
    • Affected Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      Some tasks in Moodle that use the custom user profile fields could be greatly improved by the addition of a database index on the 'userid' and 'fieldid' fields. It would also be great to have one on the 'data' field, but this is not possible as it is a 'text' type and will not work on all database technologies.

      Simply adding a new index such as 'userfieldidx' based on the 'userid' and 'fieldid' fields can speed up a number of queries.

      I have attached a patch (would need adjusting for the version bump) that would do this. This could (should) be applied to 2.0 as well.

        Attachments

          Issue Links

          duplicates

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-17201 Add index on user_info_data

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed

            Activity

              People

              Assignee:
              andyjdavis Andrew Davis
              Reporter:
              mchurch Mike Churchward
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: