tOracleOutput is very slow with existing connection

One Star

tOracleOutput is very slow with existing connection

I've created a simple job to load data into Oracle DB using tOracleOutput component.
When using exiting connections this component loads approximately 10 rows at a time. If clean up this checkbox load rates increases to 4000. Connection settings in both cases are taken from repository and absolutely identical.
This problem was already discussed here http://www.talendforge.org/forum/viewtopic.php?pid=39883 and issue was raised here http://www.talendforge.org/bugs/view.php?id=8954. However, issue was closed without any suggestion what should be done in cases when load should happen in one transaction (for example parent and child load or processing data incrementally).
Can anybody please advise how can performance be improved without implementing cumbersome workarounds?
I use TOS 4.2.2.
One Star

Re: tOracleOutput is very slow with existing connection

Can you give more information? Screenshots?
One Star

Re: tOracleOutput is very slow with existing connection

Advanced settings for the component which don't use tOracleConnection: Batch size = 10000 Commint every = 10000
One Star

Re: tOracleOutput is very slow with existing connection

Check if the "commit automatic" is desabled in your tOracleConnection.
One Star

Re: tOracleOutput is very slow with existing connection

tOracleConnection "Auto commit" is disabled
As far as I understand from the previous discussion threads, batch load is deliberately disabled when using existing connection, because of memory problems.
I wonder, how then it is possible to implement transactional load with acceptable performance?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now