Initial step for optimization

[#1]

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]

1) Check for unused fields and remove them

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

[its_anandrjs]

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

[#4 · Accepted solution]

Hi Mahesh,

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

Regards.