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

Avoid filter ES queries by ActiveGroupIds

    XMLWordPrintable

    Details

      Description

      Description

      We have executed the SignIn performance test with 100 segments, and the result shows a very important regression, you can check the full result in the table below:

      Portal Version Git Id Session Count Mean Time of Login Portal CPU Usage (%) DB CPU Usage (%) Session count changes(%)
      BaseLine e1efdfd9 39050 262 96,96,96 0,0,0  
      Segment(100 segments) e1efdfd9 1936 34200 60,60,60 28,28,28 -95.04225352

      You can find the full results here

      Also, you can download the profile from here.

      Proposed solution

      Taking a look into the profile, there is a query that takes most of the time

      So using -1 as the groupId in the Search Container will avoid calling the groups query inside com.liferay.portal.search.internal.spi.model.query.contributor.GroupIdQueryPreFilterContributor

        Attachments

          Issue Links

          is a dependency of

          Bug - A problem which impairs or prevents the functions of the product. LPS-120006 Performace issues with segments due to excesive Elasticsearch queries

          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. LPS-110846 Many Inactive Groups (Sites or deactivated Users) causes User Groups and Users and Organizations pages to load slowly or fail to load

          • Closed

          Bug - A problem which impairs or prevents the functions of the product. LPS-121537 GroupLocalServiceImpl.getGroupIds always retrieves results from database

          • Closed

            Activity

              People

              Assignee:
              team-tango Product Team Tango
              Reporter:
              cristina.gonzalez Cristina Gonzalez
              Participants of an Issue:
              Recent user:
              Enterprise Release HU
              Engineering Assignee:
              SE Support
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                20 weeks, 4 days ago

                  Packages

                  Version Package
                  7.2.X
                  Master