Alternate for Number Conversions instead of mutiple if Conditions & Challenges in optimizing the App...?

[vishalgoud]

Hi all,

Optimization for my  application become a big challenge for me, application size is  around 3GB , and Application is very slow for Clicks.

App Details :

1.using String Comparisons

2. some aggregation function

3. many " if " statements for Number Conversion like K , M & B .

4. using Count(Distinct( )) in many Charts and Objects.

What are the Best Possible Optimization techniques  we can implement to replace the Above Costly and memory taking functions...?

and also please  Send the Different Settings used to be Done in Server and QEMC to get the Better Performance..

and also as a part of optimization technique we tried to move the major calculation into back end ( Script part) but faced few more challenges ( may be we Don't know the Exact procedure for Moving the Major Calculations into the Script ) , Please Send the Best Way to Move the Calculations to the Script part..?

Any help this is highly appreciated...

Thanks in Advance.

Best regards

Vishal.

[marcus_sommer]

There are many aspects which are performance-relevant and which could be optimized. First of all - do you need really all fields and all time-periods/categories ... in your datamodel? Further you should avoid high cardinality fields and combined key-fields (use autonumber instead) and build a proper datamodel and try to categorize and/or flag those fields which are be used in calculations. See here a few links as a starting point for many others here within the community:

The Optimal QlikView Data Structure

The Importance Of Being Distinct

Conditional Aggregations

- Marcus