O'Reilly logo

Mastering QlikView by Stephen Redmond

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required