Time taken to retrieve the data from ORACLE DB , is taking more time

[yuvaalter]

Im successfully connected IN-DB to the oracle DB, while executing it takes almost 20 minutes to retrieve 30000 records from data stream out ..it is very slow..It contains CLOB Fields in the table.

Kindly help to resolve the issue.

Thanks.

[TimN]

Hi,

There are a few suggestions here.  

https://community.oracle.com/tech/developers/discussion/4283278/fetching-clob-column-faster

Regards,

Tim

[PanPP]

Hi @yuvaalter 

1) Are you using OCI client or ODBC Driver when connecting to Oracle? I would recommend using a ODBC driver.

2) You can also cache certain tools so that when you are building out workflows, the data is already processed for certain tools.

Right-click the tool, and select the cache option. 

Hope this helps.

[koppenhe]

@yuvaalter  I would recommend using an ODBC connection instead. Also, if the data is in a remote data center the latency could be caused by a VPN connection.