Book Image

Mastering QlikView

By : Stephen Redmond
Book Image

Mastering QlikView

By: Stephen Redmond

Overview of this book

Table of Contents (14 chapters)
Mastering QlikView
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 the data size, the compression setting will define the on-disk size of the Qlik file. By default, QlikView will compress a QVW file when saving it using a high compression setting. We can change this so that medium compression is used, or we...