Affects Version/s: 7.1.X, 7.2.X, Master
Component/s: Search Infrastructure
Steps to Reproduce
- Startup Liferay
- Create and deactivate Groups (500,000+) (can use MySQL script)
- Navigate to Control Panel > Users > Users and Organizations
The page would load without too much delay
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:
Change lportal to your target database schema.