Chapter 10. Improving Performance
In this chapter, we will cover:
- Reducing the number of distinct values
- Creating counter fields to avoid Count Distinct
- Creating flag fields to avoid Sum of If and other inefficient expressions
- Denormalizing for performance
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 ...
Get QlikView for Developers Cookbook 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.
