Try our conversational search powered by Generative AI!

Expensive join in PromotionInformationGetRedemptions

Found in

EPiServer.Commerce 12.17.0

Fixed in

EPiServer.Commerce 13.7.1

(Or a related package)

Created

Aug 23, 2019

Updated

Sep 11, 2019

Area

Core

State

Closed, Fixed and tested


Description

PromotionInformationGetRedemptions joins to the OrderForm table to check if an order form is a return form or not. This can be very expensive if a promotion has a lot of orders.
As this is a frequently called SP, it can have high impact on site performance and database usage.