Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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