Adjust query when creating a position in the bill of material of the production order
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.
Comments
3 comments
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
HI Martin,
The code snippet to make the adjustment.
This is very important for all customers, not just us.
I thank.
João Antonio
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.