Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-25897

User searching takes too much time when indexing is disabled

    Details

      Description

      When have millions of users, and set users.search.with.index=false, this search takes too much time (more, than 30s).

      The most time consuming operation here is ORDER BY clause when there are no limited rows according to WHERE clause and also construction LIKE ? OR IS NULL is preventing search by index. Single ORDER BY item should be enough (instead of 3), also DISTINCT before UserId is not required.

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            gabor.pusoma Gabor Pusoma (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package
                6.0.12 EE