Slow page load in My Workflow Tasks > Assigned to My Roles when 119 workflow tasks assigned to user

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X EE, Master
• Fix Version/s: 7.0.0 DXP FP14, 7.0.0 DXP SP3, 7.0.3 CE GA4, 7.0.X EE, 7.1.X, Master
• Component/s: Workflow
• Labels:
  • QA-AUTOMATION
  • backend_test
  • fw_test_unit
  • liferay-digital-enterprise-70-sp3
  • liferay-fixpack-de-13-7010
  • liferay-fixpack-de-14-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Sprint: Workflow #04 - Feb 20 - Mar 10, Workflow #05 - Mar 13 - 24
• Git Pull Request: https://github.com/liferay/com-liferay-portal-workflow/pull/28

Steps to reproduce

1. Start up Liferay on a fresh database and log in as the admin user.
2. Run the attached addUserWith10000Roles groovy script or create 10000 Roles and 1 User with these Roles.
3. Go to Control Panel > Configuration > Workflow Definition and upload the attached custom_workflow.xml definition.
4. Assign the admin user one of the "Test Roles" that was generated by the script in step 2.
5. Go to Liferay > Configuration > Workflow Configuration.
6. Set Blogs Entry to have the Custom Workflow Definition.
7. Run the attached addBlogsEntry.groovy groovy script or add a Blogs portlet to the main page and submit 119 Blogs Entries for publication.
8. Navigate to My Workflow Tasks.
9. Click on the "Assigned to My Roles" tab.

Results of Testing

Expected Result: The page loads quickly, within 5 seconds.
Actual Results: The page loads in 20 seconds.

Reproduce on:
Master: a61624d5129b8d26f7ba6a9c07f76130fd565b28
ee-7.0.x: 606d9d902aef50ca425f401e51ef30ff8d02e70e