topic Re: What Is QVD optimized and QVD un optimized in QlikView

What Is QVD optimized and QVD un optimized

Wed, 12 Aug 2015 14:46:31 GMT

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

Re: What Is QVD optimized and QVD un optimized

Qrishna — Wed, 12 Aug 2015 14:50:30 GMT

This Link can answer you question.

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

Re: What Is QVD optimized and QVD un optimized

Clever_Anjos — Wed, 12 Aug 2015 14:54:36 GMT

Simple rule:

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

Re: What Is QVD optimized and QVD un optimized

Wed, 12 Aug 2015 15:01:03 GMT

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

Re: What Is QVD optimized and QVD un optimized

Sun, 05 Feb 2017 10:46:52 GMT

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

Re: What Is QVD optimized and QVD un optimized

oknotsen — Sun, 05 Feb 2017 16:06:36 GMT

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

Re: What Is QVD optimized and QVD un optimized

oknotsen — Sun, 05 Feb 2017 16:07:11 GMT

Please start a new topic for a new unrelated question.

Thank you.

Re: What Is QVD optimized and QVD un optimized

siddheshmane — Thu, 14 Mar 2019 06:42:27 GMT

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.

Re: What Is QVD optimized and QVD un optimized

Brett_Bleess — Mon, 25 Mar 2019 19:40:50 GMT

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.htm

Regards,
Brett