<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Confirmation of Understanding Regarding Latency and Parallel Processing. in Qlik Replicate</title>
    <link>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543836#M15944</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280"&gt;@iti-attunity-sup&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q1 &amp;amp; Q2&lt;/STRONG&gt;&lt;BR /&gt;Total latency, I believe you mean Target Latency. The&amp;nbsp; calculation is&lt;/P&gt;
&lt;P class="lia-align-left"&gt;Target Latency = Source Latency + Handling Latency&lt;/P&gt;
&lt;P class="lia-align-left"&gt;This calculation is the same for both staging task and replication task.&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q3&lt;/STRONG&gt;&lt;BR /&gt;Currently, notifications do not provide detailed latency information. If you need more detail, you can set the &lt;STRONG&gt;TRACE&lt;/STRONG&gt; level for the &lt;STRONG&gt;PERFORMANCE&lt;/STRONG&gt; logger. This will allow you to find source latency, handling latency, and target latency in the task log&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q4&lt;/STRONG&gt;&lt;BR /&gt;Yes, Parallel Load is supported only for the Full Load phase, because CDC involves DML changes (insert, update, delete) that must be applied in the exact order to maintain consistency.&lt;BR /&gt;If you mean running CDC across multiple tables simultaneously, you can create multiple replication tasks, but please note that this approach will increase I/O overhead.&lt;BR /&gt;&lt;BR /&gt;Regards,&lt;BR /&gt;Desmond&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
    <pubDate>Thu, 26 Feb 2026 11:42:18 GMT</pubDate>
    <dc:creator>DesmondWOO</dc:creator>
    <dc:date>2026-02-26T11:42:18Z</dc:date>
    <item>
      <title>Confirmation of Understanding Regarding Latency and Parallel Processing.</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543802#M15943</link>
      <description>&lt;P&gt;Hello Support Team,&lt;/P&gt;&lt;P&gt;I hope you are doing well.&lt;/P&gt;&lt;P&gt;Could you please review the following questions and confirm if my understanding of the system behavior is correct?&lt;/P&gt;&lt;P&gt;▼Questions&lt;BR /&gt;1.In a Log Stream Staging task, what is the difference between Total_Latency and Source_Latency?&lt;/P&gt;&lt;P&gt;2.In a Replication task, what is the difference between Total_Latency and Source_Latency?&lt;/P&gt;&lt;P&gt;3.Using the built-in notification features, we set a latency alert threshold of 1 hour (3600 seconds), and alert emails are triggered occasionally.&lt;BR /&gt;Recently, we received alerts at almost the same time for a paired set:&lt;BR /&gt;the Log Stream task reported a latency of 3604, while the Replication task reported 3603.&lt;BR /&gt;In this scenario, what is the "actual" latency (i.e., the total time elapsed since the transaction was committed on the source side)?&lt;BR /&gt;Is it the sum of the two values (7207 seconds),&lt;BR /&gt;or should we only focus on the higher value? Or, since the tasks are paired, is the actual latency effectively the same, making the choice of which to monitor arbitrary?&lt;BR /&gt;(Note: Latency alerts always occur as a set for both paired tasks, and in almost all cases, the latency values for the Log Stream and Replication tasks are nearly identical.)&lt;/P&gt;&lt;P&gt;4.While increasing parallelism seems like a viable method to improve latency,&lt;BR /&gt;is it true that parallel processing is limited to Full Load? Is parallel processing unavailable for Apply Changes?&lt;/P&gt;&lt;P&gt;▼My Understanding&lt;BR /&gt;1.Log Stream Task:&lt;BR /&gt;Source_Latency: The time from when a transaction is committed in the source DB until Qlik Replicate captures that update.&lt;BR /&gt;Total_Latency: The time difference from the commit in the source DB until the data is successfully written to the Qlik Replicate server (staging folder).&lt;/P&gt;&lt;P&gt;2.Replication Task:&lt;BR /&gt;Source_Latency: The time elapsed until the task reads the data from the Log Stream staging folder.&lt;BR /&gt;Total_Latency: The total time gap from the commit in the source DB until the data is applied and visible in the target DB.&lt;/P&gt;&lt;P&gt;3.Combined Latency:&lt;BR /&gt;When using Log Stream,&lt;BR /&gt;I believe the sum of the latencies from the Log Stream Staging task and&lt;BR /&gt;the Replication task represents the total time it takes for data committed in the source DB to be applied to the target DB.&lt;BR /&gt;Is this recognition correct?&lt;/P&gt;&lt;P&gt;4.Parallelism in Apply Changes:&lt;BR /&gt;Aside from splitting a single task into multiple Replication tasks to achieve parallel processing for Apply Changes,&lt;BR /&gt;are there any other methods to enable parallel processing during the change application phase?&lt;/P&gt;&lt;P&gt;▼Reference Materials&lt;BR /&gt;&lt;A href="https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedEMReplicate/Console/Terminology.htm" target="_blank"&gt;https://help.qlik.com/en-US/replicate/November2024/Content/Global_Common/Content/SharedEMReplicate/Console/Terminology.htm&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Best Regards.&lt;/P&gt;</description>
      <pubDate>Thu, 26 Feb 2026 06:58:10 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543802#M15943</guid>
      <dc:creator>iti-attunity-sup</dc:creator>
      <dc:date>2026-02-26T06:58:10Z</dc:date>
    </item>
    <item>
      <title>Re: Confirmation of Understanding Regarding Latency and Parallel Processing.</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543836#M15944</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280"&gt;@iti-attunity-sup&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q1 &amp;amp; Q2&lt;/STRONG&gt;&lt;BR /&gt;Total latency, I believe you mean Target Latency. The&amp;nbsp; calculation is&lt;/P&gt;
&lt;P class="lia-align-left"&gt;Target Latency = Source Latency + Handling Latency&lt;/P&gt;
&lt;P class="lia-align-left"&gt;This calculation is the same for both staging task and replication task.&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q3&lt;/STRONG&gt;&lt;BR /&gt;Currently, notifications do not provide detailed latency information. If you need more detail, you can set the &lt;STRONG&gt;TRACE&lt;/STRONG&gt; level for the &lt;STRONG&gt;PERFORMANCE&lt;/STRONG&gt; logger. This will allow you to find source latency, handling latency, and target latency in the task log&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Q4&lt;/STRONG&gt;&lt;BR /&gt;Yes, Parallel Load is supported only for the Full Load phase, because CDC involves DML changes (insert, update, delete) that must be applied in the exact order to maintain consistency.&lt;BR /&gt;If you mean running CDC across multiple tables simultaneously, you can create multiple replication tasks, but please note that this approach will increase I/O overhead.&lt;BR /&gt;&lt;BR /&gt;Regards,&lt;BR /&gt;Desmond&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 26 Feb 2026 11:42:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543836#M15944</guid>
      <dc:creator>DesmondWOO</dc:creator>
      <dc:date>2026-02-26T11:42:18Z</dc:date>
    </item>
    <item>
      <title>Re: Confirmation of Understanding Regarding Latency and Parallel Processing.</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543973#M15955</link>
      <description>&lt;P&gt;Hello &lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/125525"&gt;@DesmondWOO&lt;/a&gt;,&lt;/P&gt;&lt;P&gt;Thank you for your response.&lt;/P&gt;&lt;P&gt;Q1 &amp;amp; Q2&lt;/P&gt;&lt;P&gt;I apologize for the confusion.&lt;BR /&gt;Total latency was meant to refer to Overall latency.&lt;/P&gt;&lt;P&gt;Q3&lt;/P&gt;&lt;P&gt;Is it correct to understand that this varies depending on the situation?&lt;/P&gt;&lt;P&gt;For example, if the situation were as follows, how would we calculate the time taken from when the update is confirmed at the Source Endpoint until the data is written to the Target Endpoint and confirmed?&lt;/P&gt;&lt;P&gt;▼Log Stream Staging Task&lt;/P&gt;&lt;P&gt;Source latency 3828.42 seconds, Target latency 3828.42 seconds, Handling latency 0.00 seconds&lt;/P&gt;&lt;P&gt;▼Replication Task&lt;/P&gt;&lt;P&gt;Source latency 3827.42 seconds, Target latency 3827.42 seconds, Handling latency 0.00 seconds&lt;/P&gt;&lt;P&gt;[My Understanding]&lt;/P&gt;&lt;P&gt;For Log Stream Staging Task:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;When source latency occurs, it represents the time taken for reading from the Source Endpoint&lt;/LI&gt;&lt;LI&gt;When target latency occurs, it represents the time taken for writing to the Log Stream Staging folder&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;For Replication Task:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;When source latency occurs, it represents the time taken for reading from the Log Stream Staging folder&lt;/LI&gt;&lt;LI&gt;When target latency occurs, it represents the time taken for writing to the Target Endpoint&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Therefore, my understanding is that simply adding the Overall Latency of Log Stream Staging Task and Replication Task would not equal the total time taken from when the update is confirmed at the Source Endpoint until the data is written to the Target Endpoint and confirmed.&lt;/P&gt;&lt;P&gt;Q4&lt;/P&gt;&lt;P&gt;Thank you for your clear explanation.&lt;BR /&gt;That helps me a lot.&lt;/P&gt;&lt;P&gt;Best Regards.&lt;/P&gt;</description>
      <pubDate>Mon, 02 Mar 2026 04:31:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543973#M15955</guid>
      <dc:creator>iti-attunity-sup</dc:creator>
      <dc:date>2026-03-02T04:31:38Z</dc:date>
    </item>
    <item>
      <title>Re: Confirmation of Understanding Regarding Latency and Parallel Processing.</title>
      <link>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543985#M15956</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/142280"&gt;@iti-attunity-sup&lt;/a&gt;&amp;nbsp;,&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;In the User Guide, the terms &lt;STRONG&gt;Source Latency&lt;/STRONG&gt;, &lt;STRONG&gt;Target Latency&lt;/STRONG&gt;, and &lt;STRONG&gt;Overall Latency&lt;/STRONG&gt; are defined. In the &lt;STRONG&gt;PERFORMANCE&lt;/STRONG&gt; logger, however, the metrics reported are &lt;STRONG&gt;source latency&lt;/STRONG&gt;, &lt;STRONG&gt;handling latency&lt;/STRONG&gt;, and &lt;STRONG&gt;target latency&lt;/STRONG&gt;. I believe the mappings should be as follows&lt;/P&gt;
&lt;TABLE border="1" width="100%"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;&lt;STRONG&gt;User Guide&lt;/STRONG&gt;&lt;/TD&gt;
&lt;TD width="50%"&gt;&lt;STRONG&gt;Performance Logger&lt;/STRONG&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;Source Latency&lt;/TD&gt;
&lt;TD width="50%"&gt;Source Latency&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;Target Latency&lt;/TD&gt;
&lt;TD width="50%"&gt;Handling Latency&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;Overall Latency&amp;nbsp;&lt;/TD&gt;
&lt;TD width="50%"&gt;Target Latency&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&lt;BR /&gt;I believe the terminology used in the User Guide is clearer and more precise. However, the application still reflects the original terms defined by R&amp;amp;D. If needed, you may open a support ticket to confirm this.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;Regarding the other latency questions, it may be easier to understand if you apply the following equation:&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;Target Latency = Source Latency + Handling Latency&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;▼Log Stream Staging Task&lt;/P&gt;
&lt;P&gt;Source latency 3828.42 seconds, Target latency 3828.42 seconds, Handling latency 0.00 seconds&lt;BR /&gt;&lt;BR /&gt;This means that latency occurs at the source endpoint. In general, target latency should remain very low because Qlik Replicate writes changes directly to disk.&lt;/P&gt;
&lt;P&gt;▼Replication Task&lt;/P&gt;
&lt;P&gt;Source latency 3827.42 seconds, Target latency 3827.42 seconds, Handling latency 0.00 seconds&lt;/P&gt;
&lt;P&gt;Again, this means the latency occurs at the source endpoint.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;Regards,&lt;BR /&gt;Desmond&lt;/P&gt;</description>
      <pubDate>Mon, 02 Mar 2026 09:49:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Replicate/Confirmation-of-Understanding-Regarding-Latency-and-Parallel/m-p/2543985#M15956</guid>
      <dc:creator>DesmondWOO</dc:creator>
      <dc:date>2026-03-02T09:49:56Z</dc:date>
    </item>
  </channel>
</rss>

