-
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:
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.
- relates
-
LPE-6335 Improved performance of UpgradePermission and VerifyPermission
-
- Closed
-