topic Re: Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance in Qlik Replicate

Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance

al3x — Thu, 28 Aug 2025 09:07:02 GMT

Hello everybody

We use Qlik Replicate to load various tables from Oracle to Postgres.

For further processing in Postgres, we have established a column with the timestamp of the transfer/commit, for example, qlik_change_ts.

However, using $AR_H_COMMIT_TIMESTAMP leads to massive performance losses during data transfer.

Is there a simple trick to prevent slowing down the transfer? Alternatively, $AR_H_COMMIT_TIMESTAMP can be removed during the transfer, although this requires extensive adjustments to the subsequent processes.

Regards
Alex

Re: Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance

john_wang — Mon, 01 Sep 2025 15:43:57 GMT

Hello @al3x ,

This appears to be the first reported case where the transformation $AR_H_COMMIT_TIMESTAMP is causing significant performance degradation. Typically, performance issues are related to either the target side being unable to handle the incoming data or the source-side capture process.

In this situation, I recommend opening a support ticket with the appropriate logging level enabled. Additionally, please clarify whether the issue occurs during the Full Load phase, the Change Processing phase, or both.

Hope this helps.

John.

Re: Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance

al3x — Mon, 01 Sep 2025 15:51:09 GMT

Hey John

Thanks for your response. Which logging level do you need exactly?

For us only the full load matters during change proessing it's less an issue.

Regards
Alex

Re: Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance

john_wang — Mon, 01 Sep 2025 16:10:15 GMT

Hello @al3x ,

Thanks for the update.

We need to set PERFORMANCE / SOURCE_UNLOAD / TARGET_LOAD / TRANSFORMATION to Trace in order to analyze the task log files. However, if the behavior occurs only during the Full Load phase, the task may be optimized by enabling features such as Parallel Load etc.

Hope this helps.

John.

Re: Qlik replicate global rules $AR_H_COMMIT_TIMESTAMP performance

al3x — Thu, 04 Sep 2025 05:56:37 GMT

I opened a support case. Thanks John.