For Web 8.5, the publishing / unpublishing process takes too long
000003519|5/1/2020 9:51 PM
Issue has been seen for the 1st time in Tridion 2011 Sp2 but may occurs on Tridion 2013 + and SDL Web 8.x
Publishing or unpublishing a complex taxonomy containing multi-parent Keywords and more than a few thousand Keywords with many related items, the deployment exceeds the transaction timeout and can take up to an hour to complete.
The solution provides an option to switch off the reference counting mechanism on Keywords. Note in the case of Web 8.5, this is applicable for the deployer microservice only:
Open your cd_storage_conf.xml in a text editor.
Set the following configuration option to the storage configuration file under the <Global> element:
Save and close cd_storage_conf.xml.
By setting CountEnabled="false", the keyword reference counts are no longer calculated impacting the following APIs:
Java Class: com.tridion.taxonomies.Keyword and method: getReferencedContentCount
.NET Class: Tridion.ContentDelivery.Taxonomies.Keyword and property: ReferencedContentCount.
The impact will result in these methods returning a '0' integer return value.
The cause of the issue is the related item count that is provided on API level. The related item count to a Keyword is calculated during deployment time due to the complexity of taxonomies with multi-parent keywords the query for each level of the taxonomy grows exponentially in time to execute.