Performance Issues in Demantra Workflows
Hello All, We are facing performance issues with Demantra workflows . Mainly calculate dep. demand wf . to have tried various steps to cope up with the issue as described below however we could only succeed partially . We still need to do more tuning . > We have purged the unnecessary data from sales_data and t_ep_Cto_data tables > We have performed reordering and reorg on sales_Data , mdp_matrix and t_ep_cto_Data tables . calculate dep demand wf used to run for 7-8 hrs . gradually it went to 12 hrs and one day it took around 24 hrs to complete