database reader

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

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

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

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.