Poor performance Database Writer to Redshift

KNIME Analytics Platform
1

Hi,

I am trying to use a Database Writer node to create a table in Redshift with approx. 20k records. Unfortunately, this takes a huge amount of time (up to more than an hour). I already set the limit to 100 and 25000 rows, but it still remains slow. Is there anything I can do to improve performance?

2

If your KNIME workflow and the Redhift instance are not sitting close together then the network delay will dominate any operations. One hour seems a bit much, though.

3

On Advance tab change batch size to say 10000.