tJDBCInput takes longer to run a query than SQL Developer

[Tushar08]

Hi All,

I have a tJDBCInput component which reads a view and then insert into table.

View is having multiple left outer joins and few arithmetic operations along with date filter condition on driving table as it is an incremental load.

Records are in millions is most of the tables.

For 7 records, when executing the query from SQL developer it takes 6 seconds while running it from talend, it takes 714 seconds (11.9 mins).

For 0 records, SQL developer takes 1.6 seconds while in talend, it takes 686 seconds (11.4 mins).

We are using cursor as well in our jobs.

Please let us know, if you have any suggestions to improve reading time from Talend.