topic Re: why loading from oracle so slow? in QlikView https://community.qlik.com/t5/QlikView/why-loading-from-oracle-so-slow/m-p/1213352#M388881 <HTML><HEAD></HEAD><BODY><P>We get a lot faster speed with Oracle if we use OLEDB.</P></BODY></HTML> Wed, 15 Mar 2017 15:21:06 GMT m_woolf 2017-03-15T15:21:06Z why loading from oracle so slow? https://community.qlik.com/t5/QlikView/why-loading-from-oracle-so-slow/m-p/1213351#M388880 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>I need to connect to oracle data sources.</P><P>I have 32 bit odbc oracle driver.</P><P>when I run the query (just a simple select * from statement), it returns instantly in sql developer.</P><P>But when I used qlikview desktop, it takes several minutes to load every several hundred records.</P><P></P><P>Any idea?</P><P>The only thing I can try is to see if 64bit driver would help. But I really don't think that is the reason.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 15 Mar 2017 15:01:17 GMT https://community.qlik.com/t5/QlikView/why-loading-from-oracle-so-slow/m-p/1213351#M388880 2017-03-15T15:01:17Z Re: why loading from oracle so slow? https://community.qlik.com/t5/QlikView/why-loading-from-oracle-so-slow/m-p/1213352#M388881 <HTML><HEAD></HEAD><BODY><P>We get a lot faster speed with Oracle if we use OLEDB.</P></BODY></HTML> Wed, 15 Mar 2017 15:21:06 GMT https://community.qlik.com/t5/QlikView/why-loading-from-oracle-so-slow/m-p/1213352#M388881 m_woolf 2017-03-15T15:21:06Z