topic [Qlik Replicate] About performance of "R4I UDTF" in Qlik Replicate

[Qlik Replicate] About performance of "R4I UDTF"

iti-attunity-sup — Tue, 23 Jun 2026 02:43:08 GMT

Source : DB2 for i Series

Hello support team.

I'd like to know difference in performance between display_journal and R4I UDTF.
If using R4I UDTF how much will performance improve from using display_journal.

Assume that change data output by 20MB/s.

Best regards.

Re: [Qlik Replicate] About performance of "R4I UDTF"

DesmondWOO — Tue, 23 Jun 2026 10:09:06 GMT

Hi @iti-attunity-sup ,

For DISPLAY_JOURNAL, it retrieves a broader range of journal entries first, and then filters them using SQL WHERE clauses. In contrast, R4I UDTF performs filtering at the source level before generating the result set. This explains why R4I UDTF delivers much better performance.

However, it is hard to quantify the exact performance improvement because it depends on the distribution of changes. For example, if we only need to retrieve 1 target record out of 1 million total journal changes, R4I UDTF will be significantly faster since it eliminates the massive overhead of checking those 1 million records through SQL clauses.

Regards,
Desmond

Re: [Qlik Replicate] About performance of "R4I UDTF"

iti-attunity-sup — Wed, 24 Jun 2026 10:19:26 GMT

Hello Desmond.

Thank you for your reply.

Does "R4I UDTF" use QjoRetrieveJournalEntries API ?

Best regards.

Re: [Qlik Replicate] About performance of "R4I UDTF"

DesmondWOO — Thu, 25 Jun 2026 02:13:32 GMT

Hi @iti-attunity-sup ,

Based on a review of previous support case regarding this architecture, yes, that is correct.

Regards,
Desmond