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