Poor performance for ecfVersionAsset_Save

Fixed in

EPiServer.Commerce 11.2.1

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.