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

              brian.wulbern Brian Wulbern
              arthur.hsiao Arthur Hsiao (Inactive)
              Felipe Lins Felipe Lins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                9 years, 48 weeks, 3 days ago

                Packages

                  Version Package
                  6.1.2 CE GA3
                  6.1.30 EE GA3
                  6.2.0 CE M6