Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Alteryx WF Oracle DB performance issue

Manikumarayyachamy
6 - Meteoroid

Hi,I have try to read the 20+ Million rows from Oracle Database and the Alteryx WF which running this SQL taking more than hour to finish it. When run the same SQL from Toad/Sql Developer its completed within 1 mins. Could you please suggest how can i improve the Alteryx WF performance when read the huge data from Oracle DB. 

 

For Data connection i have tried with Oracle OCI , ODBC & OLEDB , but none of them fixed the issue.

1 REPLY 1
Luke_C
17 - Castor

Hi @Manikumarayyachamy 

 

Have you tried the Simba Oracle ODBC driver? Check out the solution to the below post for more details

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Oracle-Database-read-speed-too-slow/td...

 

Labels