Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

optimized qvd non optimized qvd

When it is used optimized and non optimized qvd situation?

5 Replies
Colin-Albert
Partner - Champion
Partner - Champion

Anonymous
Not applicable

Not applicable

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

Anonymous
Not applicable

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
Partner Ambassador
Partner Ambassador

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