topic Re: ODBC Connection Question in QlikView

ODBC Connection Question

dinicholls — Fri, 28 Feb 2014 10:41:08 GMT

Hi,

I'm really new to QlikView, so please bear with me on this!

I'm connection to an ODBC datasource, which connects fine, no problems there, but, my database is massive! Its my understanding that the connection should just 'be there', and that QlikView wouldn't try to load all the data. My current connection is only a third of the way through, and its been running for 10 minutes plus!

Any ideas?!

Thanks

Re: ODBC Connection Question

hic — Fri, 28 Feb 2014 10:44:56 GMT

Depends on what you want to do...

During the development phase, you can use a

First 10000 SQL SELECT ...

to limit the number of records. But if you want to limit it permanently, also in the production app, you should use a WHERE clause in the SELECT, e.g.

SQL SELECT ... WHERE Year >= 2013 ;

HIC

Re: ODBC Connection Question

ThornOfCrowns — Fri, 28 Feb 2014 11:07:58 GMT

If you take either of Henric's suggestions, you can also use a Buffer load to speed up re-loading whilst developing.

See http://qlikviewnotes.blogspot.co.uk/2014/02/speed-up-script-development-with-buffer.html for more details.