VerifyResourcePermissions very slow when there are many entries to update

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, 7.3.X, Master
• Fix Version/s: 7.2.X, 7.3.10 DXP FP1, 7.3.10.1 DXP SP1, 7.3.6 CE GA7, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Database Upgrade Framework
• Labels:
  • liferay-dxp-73-sp1
  • liferay-fixpack-dxp-1-7310
  • liferay-fixpack-dxp-9-7210
• Branch Version/s:
  7.3.x, 7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/achaparro/liferay-portal/pull/742

Step to Reproduce

1. Import 6210.sql to MySQL (this database is from 6.2 where 50,000 entries were added to the Group_ table)
2. Upgrade to Master

Expected Results
VerifyResourcePermissions completes quickly (log from after fix):

Completed com.liferay.portal.verify.VerifyResourcePermissions#_verifyResourcedModel#Group_ in 59412 ms

Actual Results
VerifyResourcePermissions is slow (log from before fix):

Completed com.liferay.portal.verify.VerifyResourcePermissions#_verifyResourcedModel#Group_ in 374660 ms