Poor performance for ecfVersionAsset_Save

Fixed in

EPiServer.Commerce 11.2.1

(Or a related package)

Created

Aug 23, 2017

Updated

Sep 06, 2017

Area

Core

State

Closed, Fixed and tested

Description

If the customer has a lot of rows in ecfVersionAsset, running the stored procedure ecfVersionAsset_Save performs poorly.

It can be very expensive if the ecfVersionAsset and the parameter @ContentDraftAsset are big enough.
Also, ecfVersionAsset has a pkId column which serves no purpose.