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

Slow retrieval of layouts that are missing permissions

    Details

      Description

      Query used for retrieval all layouts that are missing permissions is inefficient because the join makes it hard for the query optimizer to realize that it can use the primary key of the Layout table. This is because we use a nullable string column from the ResourcePermission table in the join. We can fix this by instead using the non-nullable primKeyId column.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lu.liu Lu Liu
              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:
                5 years, 33 weeks ago

                  Packages

                  Version Package
                  7.0.0 DXP FP7
                  7.0.0 DXP SP1
                  7.0.3 CE GA4
                  7.1.X
                  Master