Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-27755 As a heavy WCM user, I'd like to see much shorter response times when I'm using the web content list portlet
  3. LPS-33389

Eliminate the real-time calculation of the latest version number in finder methods of JournalArticleFinder to improve performance

    XMLWordPrintable

    Details

    • Type: Technical Task
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 6.2.0 CE M5
    • Fix Version/s: 6.2.0 CE M5
    • Component/s: Environments, Environments > Databases, ~[Archived] WCM
    • Labels:
    • Environment:
      Tomcat 7 + MySQL 5.5. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.
      Tomcat 7 + Oracle 11g. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.
    • Epic/Theme:
    • Business Value:
      5

      Description

      The following queries can be optimized by materializing the latest version in a separate entity and using an inner join instead of the combination of GROUP BY and MAX(version).

      1. JournalArticleFinder.findByG_U_C
      2. JournalArticleFinder.findByG_C_S
      3. JournalArticleFinder.findByC_G_F_C_A_V_T_D_C_T_S_T_D_R

        Attachments

          Activity

            People

            • Assignee:
              laszlo.csontos Laszlo Csontos (Inactive)
              Reporter:
              laszlo.csontos Laszlo Csontos (Inactive)
              Recent user:
              Laszlo Csontos (Inactive)
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

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

                Packages

                Version Package
                6.2.0 CE M5