Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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...
Need Help
abkgo's avatar
abkgo
New Member
8 years ago

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.   

 

  • pwvtg's avatar
    pwvtg
    New Member
    8 years ago

    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

  • Nick_Church's avatar
    Nick_Church
    Frequent Visitor
    8 years ago

    I'd be really interested in an update on this one too.

     

    I completely echo abkgo's comment - I'm connecting to an Oracle view I have created with both PowerBI and Tableau, yet the extraction time between them is very different (Tableau being significantly faster). 

     

    Also - probably a separate issues I know, but when I publish a PBI book to the PowerBI service and connect via a content gateway that has been installed, the performance seems somewhat hit and miss. I'm extracting about 2.5m rows on my desktop, which takes around 20-30 however the same extraction in the PBI service takes about 2hrs and frequently times out (because its hitting the 2hr limit).