Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-31549

Improve Asset Publisher's performance if tags are used by applying the same solution pattern used for categories in LPS-28364

    Details

    • Type: Story
    • Status: Closed
    • Priority: Minor
    • Resolution: Inactive
    • Affects Version/s: 6.1.30 EE GA3, 6.2.0 CE M3
    • Fix Version/s: None
    • Environment:
      Tomcat 7.0 + MySQL 5.5 + Portal 6.2.x CE GIT ID: 817cfec11dc0922448f7d03413980756b8479e22.
      Tomcat 7.0 + MySQL 5.5 + Portal 6.1.x EE GIT ID: 32d80b3096d5dddd356cf616f8ff0972bceb88ad.

      Description

      Asset publisher's back-end layer might a be bottleneck if significant amount of assets are published for such a filter criteria which is based on tags.

      Steps to reproduce

      1) Generate 20K journal articles with the attached script (Go to Control Panel -> Server Admin -> Script and execute it as a BeanShell script).
      2) Add 4 pages (page1, page2, page3, page4) and to every page add the Asset Publisher portlet.
      3) Go to the configuration of Asset Publisher portlets.

      Select tags in Filter.

      For page1: select "Contains", "Any" and "tags" and select a few tags.
      For page2: select "Does not Contain", "Any" and "tags" and select a few tags.
      For page3: select "Contains", "All" and "tags" and select a few tags.
      For page4: select "Does not Contain", "All" and "tags" and select a few tags.

      4) Restart Liferay and log in

      Click page1. (Click on the 2000 times. But please count the times for the last 1000 clicks on page1)

      example: Selenium or QTP. (But remember that SQL query time)

      5) Restart Liferay and log in

      Click page2. (Click on the 2000 times. But please count the times for the last 1000 clicks on page1).

      example: Selenium or QTP. (But remember that SQL query time)

      6) Restart Liferay and log in

      Click page3. (Click on the 2000 times. But please count the times for the last 1000 clicks on page1).

      example: Selenium or QTP. (But remember that SQL query time)

      7) Restart Liferay and log in

      Click page4. (Click on the 2000 times. But please count the times for the last 1000 clicks on page1).

      example: Selenium or QTP. (But remember that SQL query time)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                shuyang.zhou Shuyang Zhou
                Reporter:
                laszlo.csontos Laszlo Csontos (Inactive)
                Recent user:
                Shalaka Tendulkar
                Participants of an Issue:
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package