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

      Reduce the cache size, changing the query from (segmentId, userId) to (userId).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-qa Support QA
              Reporter:
              cristina.gonzalez Cristina Gonzalez
              Participants of an Issue:
              Recent user:
              Yunlin "Steven" Sun
              Engineering Assignee:
              Cristina Gonzalez
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                45 weeks, 6 days ago

                  Packages

                  Version Package
                  7.2.10 DXP FP10
                  7.2.10.4 DXP SP4
                  7.2.X
                  7.3.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  7.3.X
                  Master