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

Many Inactive Groups (Sites or deactivated Users) causes User Groups and Users and Organizations pages to load slowly or fail to load

    Details

      Description

      Steps to Reproduce

      1. Startup Liferay
      2. Create and deactivate Groups (500,000+) (can use MySQL script)
      3. Navigate to Control Panel >  Users > Users and Organizations

      Expected Result
      The page would load without too much delay

      Actual Result
      Even after accounting for the initially slower first page load (as classes initialize), it takes over a minute for the page to load.


      [MySQL Script] - Generate 500,000 Inactive Groups

      Attached is a sql script that can be used in MySQL to generate 500,000 inactive groups for testing this issue: insert_inactive_groups.sql

      Note: The script targets the schema lportal, which can be changed by modifying the first line:

      USE lportal; 

      Change lportal to your target database schema.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                brian.lee Brian Lee
                Reporter:
                eric.yan Eric Yan
                Participants of an Issue:
                Recent user:
                Tibor Lipusz
                Engineering Assignee:
                André Ricardo Barreto de Oliveira
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 weeks, 3 days ago

                  Packages

                  Version Package
                  7.1.X
                  7.2.10 DXP FP5
                  7.2.10.2 DXP SP2
                  7.2.X
                  Master