Asset Publisher and checking permissions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 6.1.0 CE RC1, 6.1.0 CE GA1
• Fix Version/s: 6.0.X EE, --Sprint 12/11, 6.1.0 CE RC1, 6.1.1 CE GA2, 6.1.2 CE GA3, 6.1.30 EE GA3, 6.2.0 CE M2
• Component/s: WCM, WCM > Publication, WCM > Publication > Asset Publisher, Web Search, Web Search > Search Portlet
• Labels:
  • QA-PORTAL
• Branch Version/s:
  6.1.x, 6.0.x
• Backported to Branch:
  Committed

When I have about 10 000 AssetEntry and one asset publisher in my page and I want display all of them - Asset Publisher sends 30 000 queries to database in one request.
I've written about it here: http://liferaycms.wordpress.com/2011/10/11/one-of-bottleneck-in-liferay-6-1/ and here: http://liferaycms.wordpress.com/2011/10/17/asset-publisher-and-queries-count/