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

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      4

      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:
                  4 years, 2 weeks, 3 days ago