Performance issue on Project summary & edit workplan page on PPM7.1
We are using HP PPM 7.1 & facing performance issue on instance specially while loading of 'Project Summary' & 'View/Edit Workplan' page.
The seeded query which runs in backend during this which is taking Max. time is shown below:
SELECT * FROM ( SELECT PENDINGTAS1_.CREATION_DATE AS COL_0_0_ FROM PPMC46PR01.WP_TASKS TASK0_, PPMC46PR01.ITG_PENDING_ROLLUPS PENDINGTAS1_ WHERE PENDINGTAS1_.ROLLUP_TYPE_CODE='TEST' AND TASK0_.WORK_PLAN_ID=10 AND PENDINGTAS1_.SOURCE_ENTITY_PRIMARY_KEY=TASK0_.TASK_ID ORDER BY PENDINGTAS1_.CREATION_DATE ASC ) WHERE ROWNUM <= 5;
In above query '10' & 'TEST' are just example values. Actually bind variables are getting passed here.
Also, we find many such queries in backend running & many are waiting in queue to get processed, o.e. in waiting status. Hence this is causing performance issue specially in loading that project summary page.