Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38720

Performance issues in Admin user search

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.7.x, 2.8.x
    • Fix Version/s: None
    • Component/s: Kernel
    • Labels:
    • Previous Issue Keys:
      KNL-867

      Description

      Pre K1 1.1.14 a search for users would not match across first and last name fields, making it impossible to find a user by searching with the conventional name. E.g. "John Smith" would not find any one.

      Per KNL-691 this was changed so that the search entry is broken into tokens on spaces and matches are now based on an OR of finding any substring of any token in the search string in the email or name fields. Based on a code review it appears that the underlying query uses wildcards (see DbUserService.java search) and an UPPER function (see UserServiceSqlDefault.java). The upper prevents the use of an index. This means that query is potentially very expenseive when given multiple terms on a large set of users.

      This should not be wide spread problem since the query is only run by the admin user.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  k1team KERNEL TEAM (Inactive)
                  Reporter:
                  dlhaines David Haines
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code