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.
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?