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

      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:
              Marta Elicegui
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package