Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
Not applicable
Author

Thanks thats much better

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    As per my knowledge i would suggest you to use OLEDB connection, as it is more fater than ODBC.

    Hope this will help you.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Thanks thats much better