6.0.3 UpgradeAsset very slow when upgrading from 5.2.3

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.0.4 GA, 6.0.5 GA, 6.0.6 GA, 6.1.0 CE GA1, 6.2.0 CE M2
• Fix Version/s: 6.1.10 EE GA1, 6.1.20 EE GA2, 6.2.0 CE M2
• Component/s: None
• Labels: None
• Branch Version/s:
  6.1.x
• Backported to Branch:
  Committed
• Added to Fix Pack:
  Added
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/4276

When upgrading portal from version 5.2.3, the table AssetEntry is newly created without any indexes (they are created at the end of the upgrade process), and because of that the UPDATE commands in the com.liferay.portal.upgrade.v6_0_3.UpgradeAsset execute very slowly, since they search by classNameId and classPK and no index exists on those fields at the time. I was upgrading database with about 20000 records in the assets table and the single task took long hours (while all the rest of the upgrade was relatively fast). However when I tried to add the index on (classNameId,classPK) at the same time, when the UpgradeAsset was starting, I got it to finish very quickly.