Details

      Description

      the staging site is extremely slow if versioning is enabled. It can take 30 seconds to 10 minutes to refresh a page on the staging site (depends on how many contents/portlets on your page).

      Cause

      If you enable hibernate show SQL by setting the log level to DEBUG for "org.hibernate.SQL" category in "Server Administration" or use JAVA profiler, you will find the following SQL is executed hundreds of times which slows down the staging site a lot:

      SELECT LayoutSetBranch.layoutSetBranchId as layoutSe1_19_0_, LayoutSetBranch.groupId as groupId19_0_, LayoutSetBranch.companyId as companyId19_0_, LayoutSetBranch.userId as userId19_0_, LayoutSetBranch.userName as userName19_0_, LayoutSetBranch.createDate as createDate19_0_, LayoutSetBranch.modifiedDate as modified7_19_0_, LayoutSetBranch.privateLayout as privateL8_19_0_, LayoutSetBranch.name as name19_0_, LayoutSetBranch.description as descrip10_19_0_, LayoutSetBranch.master as master19_0_, LayoutSetBranch.logo as logo19_0_, LayoutSetBranch.logoId as logoId19_0_, LayoutSetBranch.themeId as themeId19_0_, LayoutSetBranch.colorSchemeId as colorSc15_19_0_, LayoutSetBranch.wapThemeId as wapThemeId19_0_, LayoutSetBranch.wapColorSchemeId as wapColo17_19_0_, LayoutSetBranch.css as css19_0_, LayoutSetBranch.settings_ as settings19_19_0_, LayoutSetBranch.layoutSetPrototypeUuid as layoutS20_19_0_, LayoutSetBranch.layoutSetPrototypeLinkEnabled as layoutS21_19_0_ FROM LayoutSetBranch WHERE (LayoutSetBranch.groupId = ?) AND (LayoutSetBranch.privateLayout = ?) AND (LayoutSetBranch.master = ?)
      

      See http://www.liferay.com/web/kzhang/blog/-/blogs/solving-performance-issue-in-liferay-6-1-staging for detailed description of the issue.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mark.jin Mark Jin (Inactive)
                Reporter:
                raymond.auge Raymond Auge
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 3 days ago