2 Replies Latest reply: Jun 2, 2011 9:08 AM by Robert Webb RSS

    ODBC LOAD - Slow on some table Quick on others

      Hi All,

       

      My workflow for creating any applications is to get the data from our Oracle data source and store into QVD containers.

       

      Table sizes range from around 10 rows to 2 million rows

       

      80% of the tables load quickly and the remainder load at a crawl, I am perplexed as to why this would happen as some of the largest tables factoring in number of columns load quickly get some of the smaller tables load slowly.

       

      Have I any options open to me in Qlikview that would improve the performance - I am also thinking of incremental loads as I can generate a unique key - I have not done incremental loads before so would appreciate some thoughts and guidance around that.

       

      Thanks in advance,


      Rob