Skip to Content
0
Dec 13, 2011 at 09:02 AM

'Strange' behaviour in KMC

58 Views

Hi experts,

We run into the following:

When we open a (wpc) webpage in our enterprise portal sometimes the responsetimes are well and sometimes really bad. This fluctuates continously, with no pattern what so ever (if executed twice right after another one can be slow and the other OK).

We have ran a Wily Introscope trace on it and found that whenever the page is slow additional actions are performed:

1. excessive database access on a few tables. It looks like it performs numerous queries which all look the same, e.g.:

38 times: SELECT "NODEID", "STRINGVALUE", "LARGESTRINGVALUE" FROM "KMC_DBRM_PROPS" WHERE "NAMESPACEID" = ? AND "LOCALNAMEID" = ? AND ("NODEID" = ? OR ...

957 times: SELECT "CHILDNODEID" FROM "KMC_DBRM_RELATIONS" WHERE "PARENTNODEID" = ? AND "HASHCODE" = ? AND "NAME" = ?

All individual SQLs are quite short, but since they are performed so many times this slows down the webpage.

2. SAP Portal|Applications|CM|Repository|Collection|TaxonomyCollection|getChildren

3. Some more actions

These additional actions cause the webpage to be slow and are not peformed when the responstime of the webpage is OK.

Does this ring a bell to anyone?

Can it have something to do with caching? Or content being changed in collaboration rooms?

Thanks,

Bart Groot