Try our conversational search powered by Generative AI!

Inefficient mdpsp_sys_DeleteMetaKeyObjects

Found in

EPiServer.Commerce 9.0.0

Fixed in

EPiServer.Commerce 11.4.1

(Or a related package)

Created

Oct 24, 2017

Updated

Nov 17, 2017

Area

Core

State

Closed, Fixed and tested


Description

mdpsp_sys_DeleteMetaKeyObjects uses conditional WHERE statements to find the MetaKeys to be deleted. That would make it very ineffective, and has caused problems when MetaKey table is big enough.