ecfVersion_ListFiltered is slow with big ecfVersion table

Found in

EPiServer.Commerce 11.0.0

Fixed in

EPiServer.Commerce 11.2.4

Created

Sep 13 2017

Updated

Sep 22 2017

Area

Core

State

Closed, Fixed and tested


Description

The stored procedure ecfVersion_ListFiltered has a lot of conditional branching and can perform badly if the table ecfVersion gets big enough.