You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by Chiranjeevi Veerni <ch...@gmail.com> on 2021/02/25 19:13:56 UTC

Batch Mode Update on Relational DB.

Hi Team,

Am planning to do batch mode updates for my destinations which are
relational DB. I had seen multiple processor options which support batch
updates.

1. PutSql
2. MergeRecord.
3. PutDatabaseRecord.

Am looking to improve the performance of the updates on the DB. Any
suggestions on which one to use and if you can share its advantages &
disadvantages if any?

Regards,
Chiranjeevi.