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
https://community.talend.com/t5/Archive/resolved-trestclient-as-lookup-into-map/td-p/182213 and issue was raised here
https://community.talend.com/t5/Design-and-Development/field-concatenation/td-p/110651. 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.