Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.