Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

ODBC LOAD - Slow on some table Quick on others

Thanks thats much better

2 Replies

ODBC LOAD - Slow on some table Quick on others

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

Not applicable

ODBC LOAD - Slow on some table Quick on others

Thanks thats much better