inserting rows of data into a database table takes forever
Hello,
I have created a workflow which results into a table with approx. 150k of rows.
I want that this output table from the workflow to be populate a table already created in my amazon redshift data base.
The problem is that this what ever node i use to write/ insert data into the database table , it takes to long , like hours/days , this is not normal
is there a way to make this more fast?
the same output from Knime , is written in a few seconds in a excel file … just for comparison …
here is the end of my workflow ,
Do ypu guys have an idea what i can do or what node to use instead of the writer node ?