[JS2-602] Portlet preferences loads from databases very slow

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.1-dev
• Component/s: Portlet Entities and Preferences
• Environment: tomcat 5.5.20, jetspeed-2.1-dev, MS SQL Server 2005 or IBM DB2 8.2 as a portal database
• Assignee: Unassigned
• Reporter: Vitaly Baranovsky
• Created: 18/Oct/06 00:29
• Updated: 04/Oct/11 21:37
• Resolved: 25/Sep/08 23:03

Description

I have page with 20 portlets. Each portlet has 35 preferences.

This preferences loads from database very slow (more than 1 minute), because jetspeed runs on portal database more than 1500 queries:

SELECT A0.NODE_ID,A0.PARENT_NODE_ID,A0.NODE_NAME,A0.NODE_TYPE,A0.FULL_PATH,A0.CREATION_DATE,A0.MODIFIED_DATE
FROM PREFS_NODE A0 WHERE (A0.FULL_PATH = :1) AND A0.NODE_TYPE = :2).

Each of this queries runs about 40 milliseconds.

So, preferences loading performance should be increased.