[
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
