About optimisation techniques

[#1]

Can any one please explain optimisation techniques for creating a dashboard?

[its_anandrjs]

Hi,

For Dashboard optimization you can follow some steps

1. Create the SET expressions.

2. Do not use If conditions in the expression part.

3. Use only useful fields and rest to be deleted.

4. Same for table not use all tables use only business tables.

5. Try to use Mapping load.

6. Make a star schema for data model.

Regards

Anand

[AbhijitBansode]

Hi, there are lot of posts available around this topic:

listed few of them.

http://community.qlik.com/message/668986#668986

http://community.qlik.com/message/654682#654682

http://community.qlik.com/message/438756#438756

Symbol Tables and Bit-Stuffed Pointers

[mukesh24]

Hi Ramana,

Optimization done at Backend(Scripting side) & also GUI perspective. First Optimize u r model then came on GUI.

Regards,

Mukesh Chaudhari.

[Anonymous]

Hi Ramana,

Optimization can be done at three levels:

Server Level

             Data Compression Technique

             Breaking single large QVW file into multiple smaller QVW

             Load Balancer

Scripting level

Removing Synthetic key

             Dropping Temporary Tables

             Handling Expressions/Calculations

             Use of Auto number Function

Design level.

             Monitoring Memory Consumption at Object Level

             Minimized Chart Vs Maximized Chart

Check http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

               http://community.qlik.com/docs/DOC-3732

               optimize and non-optimze load in qvd

               diffrence b/w optimized load and unoptimized load

Regards

Neetha

      

[#6 · Accepted solution]

Thanks Neeta,

This would be very helpful...

[Anonymous]

please close the thread,if you are happy