ODBC Connection Question

[dinicholls]

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

Di

[hic]

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

[ThornOfCrowns]

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.