Fetch rate is low for tOracleInput by default

[_AnonymousUser]

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

[Anonymous]

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