November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Unnecessary calls to ecfVersion_ListFiltered

Found in

EPiServer.Commerce 10.5.0

Fixed in

EPiServer.Commerce 11.1.0

(Or a related package)

Created

Jun 26, 2017

Updated

Aug 14, 2017

Area

Core

State

Closed, Fixed and tested

Description

ecfVersion_ListFiltered is a complex SP which does extra things, such as sorting rows, etc. In most cases, it's not needed. A simpler query would provide better performance, especially if the ecfVersion table has many rows.