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

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 8 weeks, 2 days ago

                  Packages

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