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

When perform a search, it would take a long time (and server slowed down) if many students have same lastname

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Inactive
    • Affects Version/s: 1.8
    • Fix Version/s: None
    • Component/s: Administration
    • Labels:
      None
    • Environment:
      Tested on Moodle 1.5.4+, 1.7 and 1.8
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_18_STABLE

      Description

      We found this issue on both our production live site and testing site. On the testing site, we have a lot of psudo students with last name "student" (for testing purposes), andwhen you perform a search for the name "student" (on either 1.5.4, 1.7, or 1.8), the whole site slowed as the query ran. Same thing happen when we did the same thing to search for say, @sfsu.edu (part of email address) on the LIVE production site. This search query could probably use some improvement.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: