Opening a project in Open Workbench (OWB) is taking long time. A query to retrieve all the calendars associated to the project via roles and resources is taking more time than expected.
Steps to Reproduce:
- Add 10000+ calendar and 80K resources to the PPM application.
- Create a project with 150+ tasks, 290+ team and 1900+ assignments. Make sure at least 200 resources in this team have roles associated to them.
- Open the project in OWB.
Expected Result: 1 or 2 minutes to open the project in OWB
Actual Result: Taking more than 10 minutes to open the project in OWB
Targeted for a resolution in an upcoming v13.3 Generic Patch.
Resolved in CA PPM 14.2