topic Re: Fetch rate is low for tOracleInput by default in Talend Studio

Fetch rate is low for tOracleInput by default

_AnonymousUser — Mon, 16 Jan 2017 09:42:42 GMT

Hi,

i am using tOracleInput component for fetching records. By default the fetch size is 10 hence my fetch rate is too low to process around 1000000 records. How to improve this fetch size? is there any way? Can i edit java code? I am using Talend Open Studio for this job.

Thanks,
Pawan

Re: Fetch rate is low for tOracleInput by default

Anonymous — Tue, 17 Jan 2017 01:57:33 GMT

Hi,
There is a "Use cursor" option in advanced setting of tOracleInput component which helps to decide the row set to work with at a time and thus optimize performance.Could you please check it to see if your performance is better?
Feel free to let us know your result.
Best regards
Sabrina