Try our conversational search powered by Generative AI!

Deleting property definitions causes intermittent timeout exceptions

Found in

EPiServer.CMS.Core 7.0.586.0

Fixed in

EPiServer.CMS.Core 10.2.0

(Or a related package)

Created

Oct 19, 2016

Updated

Feb 21, 2017

Area

CMS Core

State

Closed, Fixed and tested


Description

Performance of stored proc dbo.netPropertyDefinitionDelete and function dbo.GetExistingScopesForDefinition should be improved when large number of properties exists. Seems to be causing intermittent timeout exceptions, especially in SQL Azure.

This fix indirectly improves speed of stored proc dbo.netPropertyDefinitionCheckUsage (since it also uses function dbo.GetExistingScopesForDefinition),