Creating Non Routine Performance
Hi,
Has anyone experienced performance issues when creating a non routine work order in a visit? It currently takes approximately 40 seconds to a minute based on the size of the Visit to create a single non routine work order. We have run a trace on the process and it appears to be inserting significant rows into PJI_FP_AGGR_XBS_T and PA_XBS_DENORM tables.
Any help would be appreciated.
Regards,
Steve