topic Re: QVD OPTIMZED in QlikView

QVD OPTIMZED

Anonymous — Thu, 13 Mar 2014 21:37:23 GMT

Hi guys

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

thanks

Re: QVD OPTIMZED

its_anandrjs — Thu, 13 Mar 2014 21:43:31 GMT

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

Re: QVD OPTIMZED

maxgro — Thu, 13 Mar 2014 21:43:53 GMT

QVD Optimized

Re: QVD OPTIMZED

its_anandrjs — Thu, 13 Mar 2014 21:45:09 GMT

Hi,

Check this post for optimised

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

Thanks & Regards

Re: QVD OPTIMZED

Anonymous — Thu, 13 Mar 2014 21:51:00 GMT

what about

field as testfiesl?

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

Re: QVD OPTIMZED

maxgro — Thu, 13 Mar 2014 22:00:21 GMT

the log of this script

directory;

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);

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

Re: QVD OPTIMZED

Fri, 14 Mar 2014 09:02:30 GMT

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