How to verify whether the Item Cloning feature is used in a solution


Description

The Item Cloning feature simplifies some content management tasks. This convenience comes at a cost of additional operations that might affect application performance. We recommend disabling the feature if it is not used in the solution.

Solution

Execute the following query against the Master database:
SELECT COUNT(*) as NumberOfClones

FROM [dbo].[Fields]

WHERE (FieldId = '1B86697D-60CA-4D80-83FB-7555A2E6CE1C' OR FieldId = '19B597D3-2EDD-4AE2-AEFE-4A94C7F10E31') AND ([Value] <> '')

If the NumberOfClones is equal to 0 then the Item Cloning feature is not used in the solution. In this case we recommend disabling the feature:

<setting name="ItemCloning.Enabled" value="false"/>

Otherwise, we recommend that you disable the feature on all Sitecore instances except for ContentManagement and Standalone:

<setting name="ItemCloning.Enabled" value="false"/>
<setting name="ItemCloning.Enabled" role:require="ContentManagement or Standalone">
  <patch:attribute name="value">true</patch:attribute>
</setting>