topic what is optimization techniqe in datamodel and ui level? in QlikView

what is optimization techniqe in datamodel and ui level?

gkcchowdary — Thu, 31 Dec 2015 08:29:35 GMT

what are the optimization technique in datamodel and UI level

HirisH_V7 — Thu, 31 Dec 2015 08:39:04 GMT

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

maxgro — Thu, 31 Dec 2015 08:43:53 GMT

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

ashfaq's answer here

Thu, 31 Dec 2015 09:07:35 GMT