topic Re: Optimized QVD in QlikView

Optimized QVD

Tue, 28 Jan 2014 05:44:39 GMT

can any body telll me what is optimized QVD and how to do this optimization.

basic things to do for qvd optimization

Re: Optimized QVD

jagan — Tue, 28 Jan 2014 05:53:26 GMT

Hi,

There is no concept of Optimized QVD, the qvd just has data stored in it. There is a concept of Optimized QVD load, it is the one which loads the data in QVD as such without any transformation, filtering etc.

Check this link hope it helps you.

Re: Optimized .QVD Confusion

Regards,

Jagan.

Re: Optimized QVD

Tue, 28 Jan 2014 06:10:37 GMT

Hi Jagan,

in some cases we use transformations to the fields and we can store as QVds can we make those things as optimized loads can u pls expain with your words.

regrds

Mahesh T

Re: Optimized QVD

jagan — Tue, 28 Jan 2014 06:17:27 GMT

Hi,

After transformation if you store data in QVD, and if you reload this QVD again using

LOAD * FROM MyQVD.qvd

Then it is a Optimized load.

Whatever the data in QVD when you load without any transformation, filtering etc. is called Optimized QVD loading.

For example:

LOAD * FROM MyQVD.qvd;

This data will load very faster, you donot find the difference for smaller number of records.

LOAD *, Year(Date) AS Year

FROM MyQVD.qvd;

This is not an Optimized load since you are transforming the data. Hope this helps you.

Regards,

Jagan.

Re: Optimized QVD

ngulliver — Tue, 28 Jan 2014 12:25:10 GMT

Hi, Mahesh.

There is a blog written by Steve Dark on this subject:

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

Regards,

Neil

Re: Optimized QVD

Tue, 28 Jan 2014 17:54:09 GMT

Thank U .I got clarified my doubt.