topic Re: Performance ODBC with Sybase IQ in QlikView https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594177#M678946 <HTML><HEAD></HEAD><BODY><P>Hello Martijn/Darek,</P><P> Martijn- Could you please tell me what OS that machine is having (XP, Windows 7)? I am looking for Sybase ODBC drivers for Version 10 and 11.</P><P></P><P>Regards</P><P><STRONG>Advait</STRONG></P></BODY></HTML> Tue, 06 May 2014 14:32:44 GMT advait_thakur 2014-05-06T14:32:44Z Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594170#M678939 <HTML><HEAD></HEAD><BODY><P>Has anyone experience with Sybase IQ 16.0 SP3 in combination with QlikView 11 sr3?</P><P></P><P>We are experiencing that connecting through ODBC to SQL is faster than Sybase IQ.&nbsp; Were a bit lost about how to speed things up. Sybase IQ is working like a charm regarding direct SQL, but bulk loading is (SELECT * etc) is killing.</P><P></P><P>Has anyone suggestions how to speed things up?</P><P></P><P>Regards,</P><P>Martijn </P><P></P><UL style="list-style-type: disc;"><LI><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">IQ -&gt; QlikView 100mln rows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48 minutes</SPAN></LI><LI><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">SQL -&gt; QlikView 100mln rows:&nbsp;&nbsp;&nbsp; 30 Minutes</SPAN></LI></UL></BODY></HTML> Mon, 05 May 2014 06:27:54 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594170#M678939 martijn 2014-05-05T06:27:54Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594171#M678940 <HTML><HEAD></HEAD><BODY><P>Direct discovery works like a charm on Sybase IQ. But for us, Direct discovery is not the solution, because we have to rebuild our current dashboard and have to investigate how to work around the SET Analysis not being available.</P><P></P><P>We’ve tried several things, but were stuck. Does anyone have similar experiences with Sybase IQ and ODBC? </P></BODY></HTML> Tue, 06 May 2014 13:07:47 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594171#M678940 martijn 2014-05-06T13:07:47Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594172#M678941 <HTML><HEAD></HEAD><BODY><P>uff...</P><UL><LI><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">IQ -&gt; QlikView 100mln rows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48 minutes</SPAN></LI><LI><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">SQL -&gt; QlikView 100mln rows:&nbsp;&nbsp;&nbsp; 30 Minutes</SPAN></LI></UL><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">???</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">What times do you have for the same queries, but sent from native cilents of those DB's?</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><BR /></SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">regards</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Darek<BR /></SPAN></P></BODY></HTML> Tue, 06 May 2014 13:46:40 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594172#M678941 2014-05-06T13:46:40Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594173#M678942 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN lang="EN-GB" style="font-size: 10pt; font-family: Arial, sans-serif;">Native is not the problem. The results are shown within seconds... It's the ODBC that is the bottleneck. </SPAN></P><P><SPAN lang="EN-GB" style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN lang="EN-GB" style="font-size: 10pt; font-family: Arial, sans-serif;">Some background information: We're on a Proof of Concept with Sybase IQ. This is a really fast solution for our datawarehouse (realtime). Our current datawarehouse database platform is SQL Server. If we want to use our current Qlikview dashboards we will downgrade in performance regarding the data extraction. The 100 mljn rows is an example for 1 year…</SPAN></P></BODY></HTML> Tue, 06 May 2014 13:55:42 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594173#M678942 martijn 2014-05-06T13:55:42Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594174#M678943 <HTML><HEAD></HEAD><BODY><P>I know that Sybase IQ is very fast.</P><P>Did you try via ODBC but without network (from the same machine)?</P></BODY></HTML> Tue, 06 May 2014 14:09:03 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594174#M678943 2014-05-06T14:09:03Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594175#M678944 <HTML><HEAD></HEAD><BODY><P>Yes, we've tried that. Everything on the machine to exclude network issues.</P></BODY></HTML> Tue, 06 May 2014 14:12:21 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594175#M678944 martijn 2014-05-06T14:12:21Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594176#M678945 <HTML><HEAD></HEAD><BODY><P>Heb je de server al eens een keer opnieuw opgestart? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 06 May 2014 14:17:29 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594176#M678945 Anonymous 2014-05-06T14:17:29Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594177#M678946 <HTML><HEAD></HEAD><BODY><P>Hello Martijn/Darek,</P><P> Martijn- Could you please tell me what OS that machine is having (XP, Windows 7)? I am looking for Sybase ODBC drivers for Version 10 and 11.</P><P></P><P>Regards</P><P><STRONG>Advait</STRONG></P></BODY></HTML> Tue, 06 May 2014 14:32:44 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594177#M678946 advait_thakur 2014-05-06T14:32:44Z Re: Performance ODBC with Sybase IQ https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594178#M678947 <HTML><HEAD></HEAD><BODY><P>It's aserver Windows 2008, R2 Enterprise</P></BODY></HTML> Tue, 06 May 2014 14:36:55 GMT https://community.qlik.com/t5/QlikView/Performance-ODBC-with-Sybase-IQ/m-p/594178#M678947 martijn 2014-05-06T14:36:55Z