8 Replies Latest reply: May 6, 2014 10:36 AM by Martijn Schulte RSS

    Performance ODBC with Sybase IQ

    Martijn Schulte

      Has anyone experience with Sybase IQ 16.0 SP3 in combination with QlikView 11 sr3?

       

      We are experiencing that connecting through ODBC to SQL is faster than Sybase IQ.  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.

       

      Has anyone suggestions how to speed things up?

       

      Regards,

      Martijn

       

      • IQ -> QlikView 100mln rows:      48 minutes
      • SQL -> QlikView 100mln rows:    30 Minutes