QVD OPTIMZED

[Anonymous]

Hi guys

Could some one explain what will cause a non optimal load what kind of functions?

thanks

[its_anandrjs]

Hi,

When ever you load large data set by where exists command the loaded data will be optimized without this will be non optimized.

Thanks & Regards

[maxgro]

QVD Optimized

[its_anandrjs]

Hi,

Check this post for optimised

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Thanks & Regards

[Anonymous]

what about

field as testfiesl?

and date(Time,'YY-mm-dd') or TEXT(NAME) functions?

[maxgro]

the log of this script

directory;

t:

load

  rand()*1000 as f1

AutoGenerate 100000;

STORE t into t.qvd;

DROP Table t;

load

  f1 as f2

from t.qvd (qvd);

DROP Table t;

load

  text(f1) as f2

from t.qvd (qvd);

is

t << AUTOGENERATE(100000) 100.000 lines fetched

t << t (qvd optimized) 100.000 lines fetched

t << t 100.000 lines fetched

so I deduce

f1 as f2 is optimized

text(f1) isn't

in the same way you can try all Qlik functions you want

[#7]

Jonathan,

General rule:

If you do no transformation (as, a function, a where) it will be optimized

If you do ONE transformation, ONE test to imprt only part of the data, it will NOT be optimized

Exception:

It seems that if you do a WHERE with Exists() function (but with ONE argument only), it will be optimized

Fabrice