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
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.