Improving performance on Replicate Target Apply

KellyHobson — Thu, 17 Mar 2022 12:20:53 GMT

Within Task Settings -> Change Process -> Change Process Tuning

There is a setting called: Apply batched changes to multiple tables concurrently

When you select this, it should improve performance when applying changes from multiple source tables. The default is five, the maximum is 50, and the minimum is two

This is supported on Snowflake on Azure, Snowflake on AWS, Snowflake on Google, Microsoft SQL Server, Amazon Redshift, Microsoft Azure Databricks Delta, Microsoft Azure Synapse Analytics, and Microsoft Azure SQL Database.

Please see limitations:

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangtunestab.htm

Environment

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

article Improving performance on Replicate Target Apply in Official Support Articles

Improving performance on Replicate Target Apply

Environment