Skip to content

Instantly share code, notes, and snippets.

@ralfbecher
Created December 11, 2013 13:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/7910736 to your computer and use it in GitHub Desktop.
Save ralfbecher/7910736 to your computer and use it in GitHub Desktop.
QlikView solving slow QVD Load (not qvd optimized) with Where condition. A Load DISTINCT from QVD can be optimized too and is really fast (example would work without distinct although). So, this two-step approach is 2x faster.. The idea is to push the Where condition into a exists scenario.
/* Slow Load, not qvd optimized:
Bookings:
LOAD * From Bookings.qvd (qvd)
Where ID>0; // ..or with other condition: Not IsNull(ID)
*/
// qvd optimized
ExistingID:
LOAD DISTINCT ID From Bookings.qvd (qvd);
// qvd optimized
Bookings:
LOAD * From Bookings.qvd (qvd)
Where Exists(ID);
Drop Table ExistingID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment