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: Closed
    • Priority: Major 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

          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?
          Hide
          Marina Glancy added a comment -

          We have detected that this issue has been inactive for over two years and also did not collect many votes. It is possible that it has been already implemented in a more recent version of Moodle, or it is not highly demanded. There are unlimited number of ways Moodle functinality can be expanded and improved but we would like to concentrate on the features that will benefit majority of users, and which can not be implemented as plugins. If you have a suggestion for improving Moodle core, and there is no open issue for it in the tracker, please start a new forum discussion to see how many other users agree with you, and then create a new issue providing as many details as possible.

          ==BLK2YIMP20141121==

          Show
          Marina Glancy added a comment - We have detected that this issue has been inactive for over two years and also did not collect many votes. It is possible that it has been already implemented in a more recent version of Moodle, or it is not highly demanded. There are unlimited number of ways Moodle functinality can be expanded and improved but we would like to concentrate on the features that will benefit majority of users, and which can not be implemented as plugins. If you have a suggestion for improving Moodle core, and there is no open issue for it in the tracker, please start a new forum discussion to see how many other users agree with you, and then create a new issue providing as many details as possible. ==BLK2YIMP20141121==

            People

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

              Dates

              • Created:
                Updated:
                Resolved: