My sites portlet slows down the portal

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.2.X, Master
• Fix Version/s: 7.2.10 DXP FP9, 7.2.X, 7.3.5 CE GA6, 7.3.10 DXP GA1, 7.3.6 CE GA7, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Performance
• Labels:
  • ee-ts
  • liferay-fixpack-dxp-9-7210
• Branch Version/s:
  7.3.x, 7.2.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/2502

Could not provide steps because a huge ammount of data is necessary to reproduce this.

Anyway checking the code we could see that repeat a SQL query several times that is not needed.