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



      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.




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


              • Created:
                Days since last comment:
                7 years, 31 weeks, 2 days ago


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