tOracleSP - return data in larger packets

Anonymous — Sat, 16 Nov 2024 03:59:09 GMT

I am using Talend 6.4. We noticed, that when Talend is getting data from the Oracle database it does it in many very small packets, which causes poor read performance.

We've got better performance on tOracleInput components by using the "Use cursor" option.

But the problem persists with tOracleSP component.

Is there any way to change tOracleSP component behavior, to return data in larger packets? When the database returns larger BLOB there is a lot of network overhead when using small packets and this causes poor flow performance.

Re: tOracleSP - return data in larger packets

Anonymous — Thu, 28 Nov 2019 23:59:37 GMT

I'm not certain, but I've got a feeling you might be looking to use the "InsensitiveResultSetBufferSize" parameter which is described here https://docs.oracle.com/cd/E13222_01/wls/docs81/jdbc_drivers/oracle.html. Look at the Additional JDBC Parameters on the Advanced tab. As I said, I am not certain and cannot test it myself at the moment. Let me know if it works

topic Re: tOracleSP - return data in larger packets in Talend Studio

tOracleSP - return data in larger packets

Re: tOracleSP - return data in larger packets