Application is slow while saving Idea or Project Instance

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce 

1. Create a sub object of Investment example Strategy
2. Create few attributes under object strategy
3. Go to project and Idea instance and create few instances of strategy
4. Now create an aggregated attribute using one of attribute from Strategy under investment object
5. Add the newly created aggregated attribute on the Project and Idea list

Expected Result: While saving the project or idea instances should be fast

Actual Result: The performance of Idea or Project instance is too slow 

 

Environment

Release : All Supported Releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Cause

The instance of strategy attribute is created under Project/Idea Instance and when you create the aggregated attribute under Investment its going to be one to many mapping causing the query to generate the Cartesian product and hence slowing down the performance while saving any of project or idea instance 

Resolution

Create an aggregate attribute Under Project and Idea Object so that instance created under Strategy object under Project and Idea is mapped as 1:1 relationship and performance should be better. 

Additional Information

See also Slow Performance in Clarity - Best Practices / List of Known issues