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

              brian.lee Brian Lee
              eric.yan Eric Yan
              Kiyoshi Lee Kiyoshi Lee
              André Ricardo Barreto de Oliveira André Ricardo Barreto de Oliveira
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                2 years, 24 weeks, 5 days ago

                Packages

                  Version Package
                  7.1.10 DXP FP18
                  7.1.10.5 SP5
                  7.1.X
                  7.2.10 DXP FP5
                  7.2.10.2 DXP SP2
                  7.2.X
                  7.3.10 DXP GA1
                  Master