Question
Flow rules are taking much time to load in DEV environment
Hi Team,
Appreciate if any one provides why when i open the Flow rules it's taking longer time to open it. I can see it is taking 2 min approx.. to open.
Thanks!
***Updated by Moderator: Marissa to update categories***
Have you checked log files ? Is there anything interesting / relevant ?
Hi Santanu.. I have verified the log files but i didn't see any abnormalities..
@ Pratik - I can see the flow rule has the 63 entries in pr4_rule_flow table. Due to this we are seeing the slowness while loading? I assume the pega rule resolution will pick the highest version and display it in few seconds (like 2 - 5 sec)
Does the Pega tracer show where the time is being spent?
Probably a dbtrace from your DBA would be helpful just to make sure there is no issue at that level.
Have you installed any HFIX recently, if yes please share us the HFIX ID we can help with solution.
Thanks,
Narasimha
Would you want to try re-gathering stats and also re-indexing the database table pr4_rule_flow to see if there is any improvement ?