Optimized QVD

[#1]

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

basic things to do for qvd optimization

[jagan · Accepted solution]

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.

[#3]

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

[jagan]

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.

[ngulliver]

Hi, Mahesh.

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

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

Regards,

Neil

[#6]

Thank U .I got clarified my doubt.