We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

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