[jira] Created: (JS2-602) Portlet preferences loads from databases very slow

["Vitaly Baranovsky (JIRA)" <je...@portals.apache.org>]

Portlet preferences loads from databases very slow
--------------------------------------------------

                 Key: JS2-602
                 URL: http://issues.apache.org/jira/browse/JS2-602
             Project: Jetspeed 2
          Issue Type: Bug
          Components: Portlet Entities and Preferences
    Affects Versions: 2.1-dev
         Environment: tomcat 5.5.20, jetspeed-2.1-dev, MS SQL Server 2005 or IBM DB2 8.2 as a portal database
            Reporter: Vitaly Baranovsky


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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org