Loading data quickly
In Chapter 3, Best Practices for Loading Data, we discussed fast loading using incremental load and binary load.
The fastest way of loading data into QlikView is to use the Binary
statement. Binary
will load the whole data table, symbol tables, and other data from one QVW file (Qlik Sense can binary load from either a QVW or QVF file).
The fastest way of getting a single table into QlikView is from an optimized load QVD because it contains a data table and symbol table.
In this section, we will explore some other options that we need to be aware of to load data quickly.
Understanding compression settings
This might not fit exactly into a chapter on script, but it is something that we need to be aware of and because the script defines ...
Get Mastering QlikView now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.