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

• 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
• Component/s: Content Display Widgets > Asset Publisher widget, ~[Archived] WCM > Publication
• Labels:
  • assetpublisher
  • database
  • performance
• 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.
• Epic/Theme:
  • WCM
• Business Value: 3
• Git Pull Request: https://github.com/shuyangzhou/liferay-portal/pull/2032

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)