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

[#1]

hi

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

khadeer shaik.

[chiru_thota]

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

[VishalWaghole]

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

[SunilChauhan]

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

[ngulliver]

Hi, Khadeer.

Have a look at this blog on optimisation.

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

Regards,

Neil

[Anonymous]

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