Search from Web Content Display is slow for non-admin users

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP FP81, 7.0.X, 7.1.10 DXP FP11, 7.1.X
• Fix Version/s: 7.0.0 DXP FP87, 7.0.10.12 DXP SP12, 7.0.X, 7.1.10 DXP FP15, 7.1.X, 7.2.10 DXP FP1, 7.2.X, Master
• Component/s: WCM
• Labels:
  • ee-ts
  • liferay-dxp-70-sp12
  • liferay-fixpack-de-87-7010
  • liferay-fixpack-dxp-1-7210
  • liferay-fixpack-dxp-15-7110
• Branch Version/s:
  7.2.x, 7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/73950

LPS-74395 solved a search performance issue, but it still persist when searchCount() is called.

Steps to reproduce

# Start Liferay

1. Generate 30 000 Web Content. (E.g. using the attached Groovy script add_articles.groovy.)
2. Add a new non-admin User with below roles and permissions:

• Site Role: Site Administrator
• Regular Role: Power User
• Regular Role with following permission set:
  • Custom Fields: Access in Control Panel
  • Custom Fields: Add Custom Field
  • Custom Fields: Configuration
  • Custom Fields: Permissions
  • Custom Fields: Preferences
  • Custom Fields: View
  • Custom Fields > Custom Field: Delete
  • Custom Fields > Custom Field: Permissions
  • Custom Fields > Custom Field: Update
  • Custom Fields > Custom Field: View
  • Portal: View Control Panel Menu

1. Add a Web Content Display portlet to default page
2. With the created non-admin User open Configuration of Web Content Display portlet, then 'Select Web Content to make it visible'
3. Click the 'Select button'

Actual result: The list of Web Contents to select from takes ~20-30 seconds to load.
Expected result: The list of Web Content takes short to load.

With an admin user the list takes only some seconds to load.