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

["Ate Douma (JIRA)" <je...@portals.apache.org>]

     [ https://issues.apache.org/jira/browse/JS2-602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ate Douma resolved JS2-602.
---------------------------

    Resolution: Won't Fix

With Jetspeed 2.1.3 and within the 2.1.3-postrelease branch we've already improved a lot on the performance of prefs loaded (like preloading at startup).
And for Jetspeed 2.2. the whole Java Prefs back-end is replaced completely so this specific issue then won't be valid anymore anyway. 

> Portlet preferences loads from databases very slow
> --------------------------------------------------
>
>                 Key: JS2-602
>                 URL: https://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.
-
You can reply to this email to add a comment to the issue online.


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