Introduction

When is application performance tuning necessary? All the time! A QlikView document has several factors that determine how it will perform. Some of these are:

• The amount of memory on the Server

• The number of CPU cores available on the Server

• The amount of data in the document

• Efficiency of the data model

• Efficiency of the expressions in charts

• Number of objects on the layout

As a developer, you may have very little influence on some of these factors. You might have no say in the specification of the server. You may have no influence on the business decision on how many years of data need to be contained in the document. Yet you can very much influence the efficiency of the data model, the efficiency of expressions, and the number of objects on the layout. Even within the constraints of the amount of data required by the business, you can make decisions that will improve the performance.

In this chapter, we will build a large QlikView document and then make adjustments that will make...