Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-25679

UpgradePermission takes a long time for algorithms 1-5

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              michael.saechang Michael Saechang
              Reporter:
              minhchau.dang Minhchau Dang
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 18 weeks, 4 days ago

                  Packages

                  Version Package
                  6.0.X EE
                  6.1.10 EE GA1
                  6.1.20 EE GA2
                  6.2.0 CE M2