DB insert node is taking 1.5 minutes to load 200 rows! Could you please let me know how can I make it faster?
Source and destination are MariadDb tables
I tried below two options:
Added below in knime.ini config file:
Explicitly mentioned batch size in node configuration.Please see snapshot.
Please note, I am passing destination table name using flow variables. PFA. Should I be mentioning batch size also through flow variables? How to do that? Please help.