topic Re: what is a non optimized QVD? and difference between optimized and non optomized QVD? in QlikView

what is a non optimized QVD? and difference between optimized and non optomized QVD?

Mon, 10 Feb 2014 03:59:09 GMT

I am new to qlikview. can any any one give me answer please...

khadeer shaik.

Re: what is a non optimized QVD? and difference between optimized and non optomized QVD?

chiru_thota — Mon, 10 Feb 2014 04:16:00 GMT

Transformations:

Ex : (1) If (Column1,.....) as Col1

Applymap (table1,col1) as Col1,

year (Column1) as Col1

Optimized QVD :

If you do all the transformation while creating QVD itself then we call it as optimized QVD.

This QVD's are good as they improve performance.

We have to load as it is in to QVW without doing any transformations.

Ex : Load col1,col2,col3 from QVDName.QVD;

Non Optimized QVD:

If you are doing the transformations while loading the data from QVD to QVW then we call it as non optimized QVD.

Ex : Load year(col1) as Year,

applymap(tab1,col2) as col2,

col3 from QVDName.QVD;

Thanks,

Chiru

Re: what is a non optimized QVD? and difference between optimized and non optomized QVD?

VishalWaghole — Mon, 10 Feb 2014 04:31:54 GMT

Hi,

Please check this link it will help for you,

http://community.qlik.com/message/453562#453562

http://community.qlik.com/docs/DOC-3420

- Regards,

Vishal Waghole

Re: what is a non optimized QVD? and difference between optimized and non optomized QVD?

SunilChauhan — Mon, 10 Feb 2014 04:45:00 GMT

Hi ,

We can differenciate it using below simple explaination

Optimized: which have no transformation,where in load statement. i mean simple load statement converted into qvd is optimized.

Note: Qvd with exists in where clause is part of optimized qvd

Non Optimized:

Load statement with transformation , where clauses, functions used within it stored into qvd is Non optimized qvd.

Thanks

Sunil

Re: what is a non optimized QVD? and difference between optimized and non optomized QVD?

ngulliver — Mon, 10 Feb 2014 08:51:42 GMT

Hi, Khadeer.

Have a look at this blog on optimisation.

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

Regards,

Neil

Re: what is a non optimized QVD? and difference between optimized and non optomized QVD?

Anonymous — Mon, 10 Feb 2014 20:09:39 GMT

A small clarification: optimized/non-optimized is not an attribute of the QVD files. It its QVD load can be optimized or not. The rest is explained already.

Regards,

Michael