We met important situation.
One customer has about 130000 projects.
On the same PC when Admin is logged in list of all projects there is reponse time around 15 sec.
When User is logged on the same PC which has rights only for 2500 projects than response time for list of all projects is 30-40 sec.
Administrator has global rights. User has OBS rights.
has anybody same experience or any suggestion how to solve it? Our investigation (CA APM Wily Introscope) is that Clarity generates huge sofisticated queries to database. And spent a lot of CPU time on DB.