Question

Performance Issue in Shop Order

  • 20 January 2022
  • 2 replies
  • 97 views

Userlevel 5
Badge +8

Hi All,

 

Steps:

Shop Order -> Update Materials and/or Operations -> Update Routing Revision and/or Alternate

 

When the above mentioned steps are carried out in the customer’s environment (APP10 UPD 12), the process takes 20 seconds more than a Core environment.

 

It was noticed that the delay occurs when fetching the posted jobs that has procedure_name as ‘Shop_Order_Cost_Bucket_API.Batch_Calculate__’.

 

The above mentioned method has been placed in a separate queue and its details are as follows.

 

The processes and execution plan were changed and re-executed but there was no change in the total time.

 

Kindly assist in improving the performance.

 

Best regards,

Devni


2 replies

Userlevel 5
Badge +6

@Devni Panduwawala,

  1. What about the data volumes processed in both CORE and customer’s environment?
  1. Can’t we narrow down any further, to the exact place inside the method “Shop_Order_Cost_Bucket_API.Batch_Calculate__” which consumes most time?

/Shardha

Userlevel 5
Badge +8

Hi @Shardha Weeratunga,

 

Thank you for your reply.

  1. Customer’s environment has 10x more data compared to the Core environment
  2. The exact location is CURSOR get_jobs of Transaction_SYS.Get_Posted_Job_Arguments

 

Best regards,

Devni

Reply