Support for Fast Queries when using the Publishing Service

  • Description

    If your Sitecore XP solution utilizes the Fast Query API, you must maintain the Descendants table in the target database(s). The Publishing Service does not update/rebuild the Descendants table by default. This decision was made to improve the performance of the publishing process. However, you can configure the Publishing Service to allow the Descendants table to be maintained.

  • To configure the Publishing Service to allow the Descendants table to be maintained:

    • In the sc.publishing.services.xml file, specify the RebuildDescendantsTable option of the PromotionCoordinator:
    <Settings>
    ...
    <PromotionCoordinator>
      <Type>Sitecore.Framework.Publishing.DataPromotion.DefaultPromotionCoordinator, Sitecore.Framework.Publishing</Type>
      <As>Sitecore.Framework.Publishing.DataPromotion.IPromotionCoordinator, Sitecore.Framework.Publishing.Service.Abstractions</As>
      <Options>
        <RebuildDescendantsTable>true</RebuildDescendantsTable>
      </Options>
    </PromotionCoordinator>
    ...
    </Settings>

Applies to:

Publishing Service 2+

August 07, 2017
August 07, 2017

Keywords: 

  • Publishing