Adjust query when creating a position in the bill of material of the production order

João Antonio

• February 25, 2022 11:26

Hi,
When adding a material to the work order, the system is making some queries and the process takes a while.
Analyzing the query we can see that there is a conversion in the data in where.
Monitoring the environment these queries are executed an average of 750 per day;
In query 1 the suggestion is to remove this code coalesce("NUMMER",0)=0 to "NUMMER" = 0 and create a default constraint for the field as zero to have no null value.
In query 2 change the coalesce("BarCode",'')='' to "BarCode" = '' or "BarCode" is null.
In this way, all your customers will have an improvement in the performance of this operation.

 

 

Query 1.

 

Query 2.

 

Vote

1

• 

  João Antonio

  • August 30, 2022 10:51

  HI Martin

  Can you help me in this case, this query is executed more than a thousand times a day.
  I performed the test on version 2022.06 and the same behavior.

  I thank.

   

  João Antonio
• 

  João Antonio

  • October 11, 2022 11:35

  HI Martin,

  The code snippet to make the adjustment.
  This is very important for all customers, not just us.

   

  

   

  

   

  I thank.

   

  João Antonio
• 

  Martin Heigl

  • October 11, 2022 11:43

  Hi Antonio,

  please inform the BOYUM Support. I have left Boyum and now work at UNIORG :-)
  
  Regards
  Martin

Please sign in to leave a comment.