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: