Upgrade performance: VerifyUUID can take days in SQL Server

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP SP8, 7.0.X, 7.1.10 DXP FP2, 7.1.X, Master
• Fix Version/s: 7.1.10 DXP FP3, 7.1.1 CE GA2, 7.1.10.1 SP1, 7.1.X, 7.2.X, Master
• Component/s: Core Infrastructure > Upgrade Framework
• Labels:
  • 7.1UPGRADE-PERFORMANCE
  • liferay-dxp-71-sp1
  • liferay-fixpack-dxp-3-7110
• Branch Version/s:
  7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/63880

Steps to reproduce it:

1. Startup Liferay 6210 using SQL Server
2. Generate thousands of RatingsEntry objects
3. Upgrade to Master

Results:
With 1600000 RatingsEntry the process VerifyUUID#verifyUUID#RatingsEntry takes more than 4 days.

Expected Results:
The process takes a few minutes - hour