Re: what is optimization techniqe in datamodel and... - Qlik Community

gkcchowdary · ‎2015-12-31

what are the optimization technique in datamodel and UI level

HirisH_V7 · ‎2015-12-31

Hi ,

Check this,

&

1. Don't use conditions on the QVD's like where and exists

2. Don't add an extra column's to the QVD's.

3. Don't use Joins, concatenate and Keeps rather than Joins you can use Apply map()

&

script level:

1)drop temp tables

2)use mapping if possible

3)try to avoid join

ui level:

1)write conditions instead of chart in script level it self

2)observe the memory consumption of charts to populate

Hope this helps,

-HirisH

HirisH
“Aspire to Inspire before we Expire!”

maxgro · ‎2015-12-31

you can find a lot of docs about optimization in the community, just use the search (upper right)

ashfaq's answer here

Report Inappropriate Content · ‎2015-12-31

what is optimization techniqe in datamodel and ui level?