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?