Forum Discussion
Very Slow Oracle Connection Speed
Hello, I'm trying to connect to an on-primise Oracle database. I followed this instrucution and installed ODAC and instant client. This is the connection speed if I use sqldeveloper and each...
Hi, Sorry for replying to an old thread, but was this issue ever solved? - I see a few other threads reporting the same issue but with no solution. I am facing the same problem - data load from Oracle is much slower compared to other DBs (Postgres, SQL Server), especially when table has a lot of columns and/or the column size is large (ex. VARCHAR2(4000)). Tableau loads the same data at least an order of a magnitude faster - so its definitely not a network speed issue.
Would be interested in an update as well, since we have big issues with extracting data out of an Oracle DB
Export of 134k rows, 12 mixed columns.
Oracle SQL Developer: approx 1 minute
Power BI: 20 minutes