Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

What Is QVD optimized and QVD un optimized

Hi all,

Can anyone explain about QVD optimization and QVD un optimization while doing the reload

please attach example QVW file.

Thanks in advance.

Venkat

1 Solution

Accepted Solutions
Employee
Employee

Re: What Is QVD optimized and QVD un optimized

Simple rule:

don´t do any transformation or where clause (besides Exists) and your QVD would be loaded optimized

8 Replies
krishna_2644
Valued Contributor III

Re: What Is QVD optimized and QVD un optimized

This Link can answer you question.

https://community.qlik.com/thread/103707

Employee
Employee

Re: What Is QVD optimized and QVD un optimized

Simple rule:

don´t do any transformation or where clause (besides Exists) and your QVD would be loaded optimized

Not applicable

Re: What Is QVD optimized and QVD un optimized

Hi Krishna,

Thanks for your reply...

do we have any documents related to fieldloop, fieldlist and dimensionality functions.

If yes plz attach the same.

Thanks in advance

Venkat

Not applicable

Re: What Is QVD optimized and QVD un optimized

Hi,

UnOptimisedQVD: If we Prepare QVD file After Making some changes to the actual database table then we say that QVD is in standard mode or Fastmode

--> Unoptimized load or unoptimized QVDs

OptimizedQVD:

If we Prepare QVD file With out applying any changes to the actual database table then we say that QVD is in Super Fastmode

--> optimized load or optimized QVDs

oknotsen
Honored Contributor III

Re: What Is QVD optimized and QVD un optimized

That must be your personal opinion, as it has nothing to do with what Qlik means by optimized or unoptimized load.

May you live in interesting times!
oknotsen
Honored Contributor III

Re: What Is QVD optimized and QVD un optimized

Please start a new topic for a new unrelated question.

Thank you.

May you live in interesting times!
siddheshmane
Contributor

Re: What Is QVD optimized and QVD un optimized

Hi,

What if i do all my calculations like case when for example, in an SQL instead of doing an ApplyMap() or an IntervalMatch() in my Load Script, How much will it affect the performance of the report? Or will it affect the performance at all?

 

Thank you,

Siddhesh H Mane.

Support
Support

Re: What Is QVD optimized and QVD un optimized

Have a read of the Help related to QVD file optimization, this should help clarify things I believe:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/QVD_files.ht...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.