Support for Fast Queries when using the Publishing Service

Expand all | Collapse all

  • Description

    Collapse
    Note that you can only use the approach described below under limited circumstances because it might affect the performance. The approach must not be applied unless it has been preceded with performance testing.

    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.

  • Solution

    Collapse

    Apply the following patch to the Publishing Service host configuration: 

    <Settings>
      <Sitecore>
        <Publishing>
          <Services>
            <PromotionCoordinator>
              <Options>
                <RebuildDescendantsTable>true</RebuildDescendantsTable>
              </Options>
            </PromotionCoordinator>
          </Services>
        </Publishing>
      </Sitecore>
    </Settings>

  • Notes

    Collapse
    • Because Federated Experience Manager (FXM) uses fast queries, its behavior is affected if the Descendants table is not maintained. Therefore, we recommend that you enable maintenance of the Descendants table if FXM is used, provided that it has been preceded with performance testing.

Applies to:

Publishing Service 2+

August 07, 2017
June 03, 2020

Keywords: 

  • Publishing