Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vikramqlik9
New Contributor

What is optimized and unoptimized qvd ?

What is optimized and unoptimized qvd ?

4 Replies
ashwinishinde
New Contributor III

Re: What is optimized and unoptimized qvd ?

hello,

You can think of an unoptimized load as reading the table one record at a time.

Whereas, the optimized load is reading in chunks of records at a time.

If your QVDis relatively small you will hardly notice a difference.  When you are working with larger QVDs you will definitely see the impact. 

vikramqlik9
New Contributor

Re: What is optimized and unoptimized qvd ?

Can you please explain me in very basic level.

ashwinishinde
New Contributor III

Re: What is optimized and unoptimized qvd ?

As per my knowledge , a simply way to define is:

A load from qvd with out any transformation is optimized load

A load from qvd with data transformation will be un- optimized

eg:

optimized

load * from a.qvd



un-optimized :

load if(column1='a', column2-1, column2-3) as new column,

*

from a.qvd

Khan_Mohammed
Honored Contributor II

Re: What is optimized and unoptimized qvd ?

Optimized QVD is 'As IS' fields with no transformation

Un-optimized is with transformation as Ashwini explained above

Optimized QVD always loads fast compared to Un-optimized. Even if you transform your QVD, store it and then read the QVd back again, so that it runs faster (if space is not an issue on server)

Community Browser