UpgradePermission takes a long time for algorithms 1-5

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.0.12 EE, 6.1.10 EE GA1
• Fix Version/s: 6.0.X EE, 6.1.10 EE GA1, 6.1.20 EE GA2, 6.2.0 CE M2
• Component/s: Core Infrastructure
• Labels: None
• Branch Version/s:
  6.1.x, 6.0.x
• Backported to Branch:
  Committed
• Added to Fix Pack:
  Added
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/4294

Let's assume that we have 80,000 users in the database, resulting in at least 80,000 groups in the Group_ table.

When using permissions algorithms 1-5, v6_1_0.UpgradePermission will call PermissionLocalServiceUtil.setContainerResourcePermissions 15 times. Each time it makes this call, there will be 80,000 select statements just to determine which communities have an entry in the Resource_ table for the model type. This results in 1.2 million select statements.

By querying the Resource_ table directly, we can reduce the 1.2 million select statements to 15 select statements.