Performance improvement when saving PWOs. (4331175)

There are two scenarios in which the storage of PWOs takes an unreasonable amount of time:

1.) Many order items in a shopping basket become many PWOs, which take a long time to store.

2.) The calculation of all decision-makers in a decision workflow takes a long time.

If DecisionOnInsert is on, the decision maker is already calculated in the insert trigger for all decision steps. Depending on the complexity of the workflow and the decision method used, this can potentially take a lot of time.

For optimisation, only the steps for which this is necessary should be calculated in the INSERT. So first for the first one.

If the customiser approves this (due to DecisionOnInsert), and it is still "ReUseDecision" on, another one would have to be calculated. As soon as the order is saved, a PWOHelperPWO order comes again anyway, which can then calculate the decision makers for ALL remaining steps.

An enhancement request (#33989) has been created.

WORKAROUND

None.

STATUS

The product team will evaluate the request and this feature may become available in a future release of the product.