Optimization at Script Level

Here are some performance optimization tips for QlikView scripting.


1. Remove unused fields. No use loading them and taking up precious server resources!

2. Do not use LOAD *;
This is difficult to debug and maintain especially when you change your table structures..

3. Do optimized load from QVD as UNoptimized load takes up more memory.

4. Use integers to join tables where possible. Or convert the string keys to integer using autonumberhash128 at script level. Numeric fields take up less memory than Strings.

5. Remove unused snowflake tables

6. Eliminate small “leaf” tables by using Mapping Load to roll code values into other dimensions or fact tables.

7. Eliminate Count(Distinct x)’s. They are very slow

8. Move as much business logic to the database server.