Try our conversational search powered by Generative AI!

AI OnAI Off

Performance improvements in cls_RecentReferenceHistory

Fixed in

EPiServer.Commerce 13.1.0

(Or a related package)

Created

Feb 22, 2019

Updated

Apr 11, 2019

Area

Core

State

Closed, Fixed and tested

Description

Feedback from a customer shows that, in an import job,a large number of organizations degrades performance. Adding an index like the one below makes the process 10-20 times faster.

CREATE INDEX ix1cls_RecentReferenceHistory ON cls_RecentReferenceHistory(Objectid,UserId,MetaClassName) 
GO