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-33388

Optimize JournalArticleFinder.countByC_G_F_C_A_V_T_D_C_T_S_T_D_R

    XMLWordPrintable

    Details

    • Type: Technical Task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
    • Fix Version/s: 6.2.0 CE M5
    • Component/s: Environments, Environments > Databases, 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.

      Description

      There is no need to calculate the lastest version by using the combination of GROUP BY and MAX(version), because it's enough to count each matching articleId with a COUNT(DISTINCT ...)

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. LPS-40695 Recent selector doesn't show all the recent articles to a regular users with view permissions

          • Closed

          Regression Bug - Used by Liferay QA to indicate an issue discovered during regression testing LPS-34924 CustomSQLUtil.replaceOrderBy(...) doesn't handle ambiguous columns well

          • Verified
          relates

          Improvement - An improvement or enhancement to an existing feature or task. LPE-8532 Optimize SQL for Web Content

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 39 weeks, 5 days ago

                  Packages

                  Version Package
                  6.2.0 CE M5