Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

why loading from oracle so slow?

Hi guys

I need to connect to oracle data sources.

I have 32 bit odbc oracle driver.

when I run the query (just a simple select * from statement), it returns instantly in sql developer.

But when I used qlikview desktop, it takes several minutes to load every several hundred records.

Any idea?

The only thing I can try is to see if 64bit driver would help. But I really don't think that is the reason.

Thanks.

1 Reply
m_woolf
Master II
Master II

We get a lot faster speed with Oracle if we use OLEDB.