Poor performance for ecfVersionAsset_Save
Aug 23 2017
Sep 06 2017
Closed, Fixed and tested
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.