Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-26222 Performance improvement of user indexing
  3. LPS-26223

Performance improvement of the query used to retrieve the users for indexing

    Details

      Description

      According to the current logic in the UserIndexer, when indexing all the users, the users to be indexed are being queried up based on the companyId. Usually this is not a good search criteria, because even though there is an index on the companyId column, there are no more than 2 companyIds in the system, so the databases will end up reading the whole table. This is very inefficient if there are several records in the user_ table, ie. on oracle the read time for every batch is growing linearly. On the other hand the userId is a great seartch criteria because there is an index as well, and has a large deviation instead of being of a singular value, and this deviation makes it a perfect candidate for an index based searching.

        Attachments

          Activity

            People

            Assignee:
            michael.saechang Michael Saechang
            Reporter:
            mate.thurzo Mate Thurzo (Inactive)
            Recent user:
            Randy Zhu (Inactive)
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              8 years, 18 weeks, 6 days ago

                Packages

                Version Package
                6.0.X EE
                6.1.20 EE GA2
                --Sprint 11/12
                6.2.0 CE M2