17 Replies Latest reply: Nov 10, 2016 5:24 PM by Boris Tyukin RSS

    Why is Oracle extract so slow?

    Simon Hogg

      I'm extracting a table from Oracle - 2.2 million rows, 10 columns, and the extract/load job in Qlik Sense took over 8 hours.

       

      Using the Oracle SQL Developer tool, I downloaded the same data into a csv file in under 30 minutes, then loaded it into Qlik Sense in less than a minute.

       

      Is there a page of tips to speed up the Qlik-Oracle connection? (ODBC via a 64-bit system DSN).

       

      (I think I can probably get away with a single one-off load followed by daily differential loads, but it would be good to have an answer on hand).