Optimized and unoptimized QVD Load Situations?

[#1]

Optimized and unoptimized QVD Load Situations?

[its_anandrjs]

In your load if you use where exists key word for the table load and make the QVD then then QVD get optimized due to you load it conditionally and make the QVD if not use it will be Optimized QVD.

Refer this documents

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

Re: Optimized .QVD Confusion

[alexandros17]

When you load your qvd, if you use Where or if statement

Ex.

Load

...

if(myfield=cond,1,2) as newfield

...

From ...

Where othercondition

You obtain a not optimized qvd (slow)

If you only use Load .... from.... this is optimized and fast

[its_anandrjs]

Suppose you load a simple table

TableName:

Load * From QVDLocation;

//The above table is optimized load

TableName:

Load *

Month(DateField) as Month,

Year(DateField) as Year

From QVDLocation;

//This is not optimized load

But if you use Store TableName into TableName.qvd;

then use TableName as load statement then QVD will be optimized

Load * From TableName;

[#5]

thankyou

[ngulliver]

Hi, Chandramohan.

If you use the search box in the top right corner you will find many answers to your questions. Your question about optimization was asked quite recently by someone else.

Have a look at their answers:

diffrence b/w optimized load and unoptimized load

Cheers,

Neil

[#7]

go through this link

file:///C:/Users/Administrator/Downloads/QlikView%20Optimization%20Best%20Practices.pdf

[#8]

Thankyou

[#9]

hi chandra r u preparing for interview ?

[#10]

yes.