The response time when clicking on Access Groups is very long
Access group landing page is taking too much time to load the page. In our application we have total 8298 operators presents at this moment. I hope for large scale applications this number is not that much. Did anyone of you face this kind of problem in your application before? It will be really helpful if you can help me to solve this problem.
Also i have checked all the backend implementations and everything is final over there. I would really appreciate if you can give me any suggestions.
***Edited by Moderator: Pallavi to update platform capability tags***
Thanks for your reply. Yes there are four alerts first PEGA0005 then two PEGA0001 and after that one PEGA0037. Main root cause that i can think about is because of the query.
Database operation took more than the threshold of 1000 ms: 149,396 msSQL: SELECT Count("PC0"."PYLABEL") AS "pySummaryCount(1)" , "PC0"."PYACCESSGROUPADDITIONAL" AS "pyAccessGroupAdditional" FROM PEG10_APP_DATA.pr_index_operators "PC0" WHERE "PC0"."PXOBJCLASS" = ? GROUP BY "PC0"."PYACCESSGROUPADDITIONAL" ORDER BY "PC0"."PYACCESSGROUPADDITIONAL"
It is taking too much time to get the result set. All of these things are Pega OOTB and final. Can you please suggest something?