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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X, Master
• Fix Version/s: 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
• Component/s: Search Infrastructure
• Labels:
  • backend_test
  • ee-ts
  • liferay-dxp-71-sp5
  • liferay-dxp-72-sp2
  • liferay-fixpack-dxp-18-7110
  • liferay-fixpack-dxp-5-7210
  • marketplace-portal-search-elasticsearch7-3.0.1-7210
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Sprint: Search|S03 Sprint 14| 4.6-4.27
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/87860

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.