topic Re: Initial step for optimization in QlikView

Initial step for optimization

Tue, 25 Feb 2014 17:24:36 GMT

Hi,

i have the data in millions.i wan to do performance optimization.

what is the initial step to involve in optimization is it better to apply condition on reducing the data or else if any

check list in order in scripting,Ui and server level.

regards

Mahesh

Clever_Anjos — Tue, 25 Feb 2014 17:30:12 GMT

1) Check for unused fields and remove them

2) Check the cardilality of fields (how much distinct?)

its_anandrjs — Tue, 25 Feb 2014 17:40:54 GMT

Hi,

First of all please check necessary fields and use them.

Second one of possible break data in different tables or fields for reduction and make QVD of them and use those QVD where ever necessary.

Third one do not completely load all data if all data is not used load minimum data and use the data for presentation.

Thanks & Regards

HTH

Tue, 25 Feb 2014 18:17:00 GMT

Hi Mahesh,

Please check my post in performance big app huge data set 500 million records thread, maybe it can helps to you.

Regards.