Hi,

we are trying to get in practice WebSphere Portal Document Manager. We
created
approximately 4000 folders. If we are clicking on Document Page it cost lot
of time (more then one minute).
Now we search for problem. Load on Portal server is minimal, on Oracle
DB server it's 100%. So we tracked WCMDBADM user (WPCP50 admin) and
found SQL Statement, that run over one minute :

SELECT   PATH.resourcecollection, PATH.NAME, PATH.projectid projectid,
PATH.workspace workspace, PATH.publishable publishable,
PATH.cacheable cacheable, wpcpmetadata.wpcpactivation,
wpcpmetadata.wpcpcfgfld1, wpcpmetadata.wpcpcfgfld2,
wpcpmetadata.wpcpcfgfld3, wpcpmetadata.wpcpcfgfld4,
wpcpmetadata.wpcpcfgfld5, wpcpmetadata.wpcpcfgfld6,
wpcpmetadata.wpcpcfgfld7, wpcpmetadata.wpcpcfgfld8,
wpcpmetadata.wpcpcfgfld9, wpcpmetadata.wpcpcfgfld10,
wpcpmetadata.wpcpcreationdt, wpcpmetadata.wpcpcreator,
wpcpmetadata.wpcpdeleted, wpcpmetadata.wpcpdescript,
wpcpmetadata.wpcpexpiration, wpcpmetadata.wpcpkeywords,
wpcpmetadata.wpcplanguage, wpcpmetadata.wpcplastmodify,
wpcpmetadata.wpcpmodifier, wpcpmetadata.wpcpprojectid,
wpcpmetadata.wpcpresourcecol, wpcpmetadata.wpcptitle,
wpcpmetadata.wpcptype, wpcpmetadata.wpcpversionid,
wpcpmetadata.wpcpworkspace, wpcpmetadata.wpcpguid
FROM PATH, path_m, wpcpmetadata
WHERE (    (PATH.projectid = '102')
AND ((PATH.workspace = 'base'))
AND (    (   (wpcpmetadata.wpcpdeleted = 'N')
OR (wpcpmetadata.wpcpdeleted IS NULL)
OR (wpcpmetadata.wpcpdeleted = '')
)
AND (   (wpcpmetadata.wpcpexpiration >
TO_DATE ('2004-04-01 12:58:51',
'yyyy-mm-dd hh24:mi:ss'
)
)
OR (wpcpmetadata.wpcpexpiration IS NULL)
)
)
AND (    (PATH.resourcecollection = 'com.ibm.wcm.Fileresource')
AND (PATH.NAME LIKE '%')
)
)
AND (    path_m.resourcecollection = PATH.resourcecollection
AND path_m.NAME = PATH.NAME
AND wpcpmetadata.wpcpguid = path_m.wpcpguid
AND wpcpmetadata.wpcpworkspace = PATH.workspace
AND wpcpmetadata.wpcpprojectid = PATH.projectid
)
ORDER BY PATH.NAME ASC


We found wrong lines in that statement and after correction it run under
second.

But where in WebSphere Portal we can repair that statement (in portlet?, in
OracleDB?) ??

In Internet I cannot found any fix to resolve this problem. Please help.

many thanks for every ideas
Robert

[ Post a follow-up to this message ]

You may want to send this to IBM Portal support level 2 or 3 group. This may
be a potential fix that other customers can leverage. To my knowledge, SQLs
are not reconfigurable since they are built into the Portlet.

Dexthor.

"Robert Bohonek" <robert.bohonek@osu.cz> wrote in message
news:c63cb1$4s5i$1@news.boulder.ibm.com...
> Hi,
>
> we are trying to get in practice WebSphere Portal Document Manager. We
> created
> approximately 4000 folders. If we are clicking on Document Page it cost
lot
> of time (more then one minute).
> Now we search for problem. Load on Portal server is minimal, on Oracle
> DB server it's 100%. So we tracked WCMDBADM user (WPCP50 admin) and
> found SQL Statement, that run over one minute :
>
> SELECT   PATH.resourcecollection, PATH.NAME, PATH.projectid projectid,
>         PATH.workspace workspace, PATH.publishable publishable,
>         PATH.cacheable cacheable, wpcpmetadata.wpcpactivation,
>         wpcpmetadata.wpcpcfgfld1, wpcpmetadata.wpcpcfgfld2,
>         wpcpmetadata.wpcpcfgfld3, wpcpmetadata.wpcpcfgfld4,
>         wpcpmetadata.wpcpcfgfld5, wpcpmetadata.wpcpcfgfld6,
>         wpcpmetadata.wpcpcfgfld7, wpcpmetadata.wpcpcfgfld8,
>         wpcpmetadata.wpcpcfgfld9, wpcpmetadata.wpcpcfgfld10,
>         wpcpmetadata.wpcpcreationdt, wpcpmetadata.wpcpcreator,
>         wpcpmetadata.wpcpdeleted, wpcpmetadata.wpcpdescript,
>         wpcpmetadata.wpcpexpiration, wpcpmetadata.wpcpkeywords,
>         wpcpmetadata.wpcplanguage, wpcpmetadata.wpcplastmodify,
>         wpcpmetadata.wpcpmodifier, wpcpmetadata.wpcpprojectid,
>         wpcpmetadata.wpcpresourcecol, wpcpmetadata.wpcptitle,
>         wpcpmetadata.wpcptype, wpcpmetadata.wpcpversionid,
>         wpcpmetadata.wpcpworkspace, wpcpmetadata.wpcpguid
>    FROM PATH, path_m, wpcpmetadata
>   WHERE (    (PATH.projectid = '102')
>          AND ((PATH.workspace = 'base'))
>          AND (    (   (wpcpmetadata.wpcpdeleted = 'N')
>                    OR (wpcpmetadata.wpcpdeleted IS NULL)
>                    OR (wpcpmetadata.wpcpdeleted = '')
>                   )
>               AND (   (wpcpmetadata.wpcpexpiration >
>                           TO_DATE ('2004-04-01 12:58:51',
>                                    'yyyy-mm-dd hh24:mi:ss'
>                                   )
>                       )
>                    OR (wpcpmetadata.wpcpexpiration IS NULL)
>                   )
>              )
>          AND (    (PATH.resourcecollection = 'com.ibm.wcm.Fileresource')
>               AND (PATH.NAME LIKE '%')
>              )
>         )
>     AND (    path_m.resourcecollection = PATH.resourcecollection
>          AND path_m.NAME = PATH.NAME
>          AND wpcpmetadata.wpcpguid = path_m.wpcpguid
>          AND wpcpmetadata.wpcpworkspace = PATH.workspace
>          AND wpcpmetadata.wpcpprojectid = PATH.projectid
>         )
> ORDER BY PATH.NAME ASC
>
>
> We found wrong lines in that statement and after correction it run under
> second.
>
> But where in WebSphere Portal we can repair that statement (in portlet?,
in
> OracleDB?) ??
>
> In Internet I cannot found any fix to resolve this problem. Please help.
>
> many thanks for every ideas
> Robert
>
>

[ Post a follow-up to this message ]