Affects Version/s: 7.1.X, 7.2.X, Master
Component/s: User Management > Users & Organizations
Getting the list of My Sites is very slow when there are many organizations with no site
Steps to reproduce
1. Start a clean 7.1 bundle (dxp-17) connected to an empty MySQL database
2. Login to Liferay
4. Go to CP > Server Administration > Script
5. Run the following script to generate 44,000 organizations (with no site)
6. Click on the compass icon "Go to Other Sites" from the product menu
7. Go to "My Sites" tab
8. Note it takes about 10 seconds to display 2 sites
Takes 10 seconds to display 2 sites. The more organizations there are, the more it takes.
For the customer, it took 20 seconds.
Page load is fast as there are only 2 sites to display.
- master commit (896f13d991710dbbc49980cd80e3a3df6436c65b)
21 seconds to load My Sites (44,000 records)
- 7.1 dxp-17
* Please see Zendesk Support tab for further comments and attachments.