Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

dinicholls
Not applicable

ODBC Connection Question

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

2 Replies
Henric_Cronström
Not applicable

Re: ODBC Connection Question

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
Not applicable

Re: ODBC Connection Question

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.