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

Staging queries are made for every layout due to LayoutLister.getLayoutView()

    Details

      Description

      The method: LayoutLister.getLayoutView()
      seems to be slowing the "manage pages" down because it has a recursive method called _createList(long parentLayoutId, int parentId, int depth) which iterates through each layout to get the child layouts of each set. For example, if you have a number such as 10,000 pages, then it will call _createList_createList() 10,000 times and you will have 10,000 queries in the database. Based on the testing, we believe this is what's causing the slowness.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.wulbern Brian Wulbern
              Reporter:
              arthur.hsiao Arthur Hsiao (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 16 weeks ago

                  Packages

                  Version Package
                  6.1.2 CE GA3
                  6.1.30 EE GA3
                  6.2.0 CE M6