Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkcchowdary
Contributor

optimized qvd non optimized qvd

When it is used optimized and non optimized qvd situation?

5 Replies

Re: optimized qvd non optimized qvd

neetha_p
Honored Contributor

Re: optimized qvd non optimized qvd

Not applicable

Re: optimized qvd non optimized qvd

Hi,

Understood like this-----

optimized qvd--  data fetch from data source and store into qvd without any where clause,conditions is called optimized qvd.in optimized qvd only you use exits function in where clause.

non optimized qvd- data fetch from data source with conditions and calculations then store in to qvd is known as non-optimized qvd.

Regards

balkumarchandel
Valued Contributor II

Re: optimized qvd non optimized qvd

Qvd optimization is not about fetching data from database and storing to qvd .

Its about loading data from qvd to RAM.

So when we are loading our application from qvd without any transformation , without any where clause load is optimized

if we do any transformation load is not optimized except exists() function.

brian_booden
Contributor

Re: optimized qvd non optimized qvd

Hi,

You should check out the post from a while ago from stevedark

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

It's one of the nicer explanations i have seen of optimised loads.

Regards,

Brian

Community Browser