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 Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • 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
    • Rank:
      1751

      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.

        Activity

        Hide
        Dan Marsden added a comment -

        Hi Wen - is this still an issue under 1.9?

        Show
        Dan Marsden added a comment - Hi Wen - is this still an issue under 1.9?

          People

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

            Dates

            • Created:
              Updated: