-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 6.2.X EE, 7.0.X EE, Master
-
Fix Version/s: 6.2.X EE, 7.0.0 DXP FP14, 7.0.0 DXP SP3, 7.0.3 CE GA4, 7.0.X EE, 7.1.X, Master
-
Component/s: Performance
-
Branch Version/s:7.0.x, 6.2.x
-
Backported to Branch:Committed
-
Story Points:1.25
-
Fix Priority:3
-
Git Pull Request:
Description
Too many database queries are run when visiting a page with an Announcements portlet as a logged in user. This can cause performance issues.
Steps to Reproduce
- Start Liferay and log in as the admin user.
- Add the announcements portlet to the home page.
- Click on the top-right corner tri-dot icon of the announcements portlet and go to Configuration.
- Under "Announcements Displayed", uncheck the box that says "Customize Announcements Displayed".
- Navigate to Control Panel > Server Administration > Scripts, and run the attached addManySites groovy script.
- Revisit the home page while still logged in. Monitor the db queries that are being run as the home page loads.
Expected Results: There will be only be a few queries that are run.
Actual Results: There are over twice as many queries as there are sites. This may lead to performance issues.
Reproduced in:
master (2605ba5ba89c29d969874317b8174d8980d1b704)
ee-7.0.x (13a6daf7cbf7833e96b7942943353b75b02b52ba)
ee-6.2.x (f55de9ba77b79dc0dd60e44c921a1aff395eb886)
- relates
-
LPE-15825 Viewing an announcements portlet can flood the database with queries if there are many sites
-
- Closed
-