Total order weight calculation UI customization performance input

Update:

I switched the part look up from part adapter get by ID to a dynamic query adapter using a baq that pulls the info from the part table that takes the current line partnum as a parameter.

WOW! The increase in performance of the calculation is incredible!

With the Part adapter GetByID method my calculation averaged a 22.7 Second exec time. With the Dynamic Query Adapter using a BAQ to grab the same info the calculation averaged 0.589 Second exec time.

The only downside is having to manage a BAQ with a method but with good documentation and organization that shouldn’t be a problem. Id rather do that than have my users wait 1 min on a calculation on each order throughout the day.

Thanks everyone!

Keep the combo Dynamic query adapter and accompanying BAQ as a tool in your toolbox!

1 Like