topic Re: optimization in QlikView

optimization

prabhas277 — Wed, 27 Jan 2016 06:39:08 GMT

HI experts,

i have one qvd located in some folder now how can i identify weather that qvd is optimized or unoptimized ? explain with examples?

thanks in advance..

Re: optimization

marcus_sommer — Wed, 27 Jan 2016 06:43:18 GMT

A qvd itself is always stored in an optimized format - to waht you refer is the (re)load of a qvd which is then optimized when no (real) transformation will be applied. Exceptions are where-clause with exists(field) or renaming of fields - in this cases no processing happens and the file-content will be directly transferred into the RAM.

- Marcus

Re: optimization

jagan — Wed, 27 Jan 2016 06:46:10 GMT

HI,

A QVD is itself is optimized, if you reload without any changes then it will load Optimized mode otherwise it will load in super fast mode.

Regards,

jagan.

Re: optimization

Anonymous — Wed, 27 Jan 2016 06:47:42 GMT

check this?

diffrence b/w optimized load and unoptimized load

optimize and non-optimze load in qvd

Re: optimization

anat — Wed, 27 Jan 2016 06:49:37 GMT

while loading the data from qvd you will see below screen like (qvd optimized)