Improvement with 9.1.3.0.sql update

Fixed in

EPiServer.Commerce 13.1.0

Created

Feb 14, 2019

Updated

Apr 11, 2019

State

Closed, Fixed and tested


Description

A customer with very big database complained about the update script in 12.14.0, where we improved the loading of catalog content by introducing the CultureSpecific column in ecfVersionProperty and CatalogContentProperty. They have 80m rows in CatalogContentProperty and about 173m rows in ecfVersionProperty.

One potential improvement is to change the column to be NOT NULL, with default value of 0. Then, just update the value of the different rows.