Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks thats much better
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
Thanks thats much better