database reader


#1

Hi

I want to do a join from an xls to a oracle database i have connected to already. When I add my database reader node on to bring in 2 columns from a table its taking ages. there are 500k rows in each column

Is there a better way to do this?

I ultimately want to join from the xls file to the database

Thanks


#2

Hi!

You need to use Database Writer to add those rows. Don’t see any other way. In Database Writer node under tab Advanced you have Batch size. By default it is 1. Try setting it to 1000 and give it a go.

Br,
Ivan


#3

Thanks Ivan, it took a while but it eventaully completed. i reduced my query size as well whichi i think helped