why loading from oracle so slow?

[#1]

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.

[m_woolf]

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