optimized & unoptimized

[qlikview979]

Hi experts,

What is the script for optimized & unoptimized  QVD ?

[rubenmarin]

Hi Mahesh, optimized load from qvd is when you load as it is, without doing any calculations or filtering data, in example:

Optimized load:

LOAD * From QvdFile.qvd;

Unoptimized load:

LOAD * From QvdFile.qvd where 1=1;

[datanibbler]

Hi mahesh,

there is no difference in the syntax. The difference is just in the speed at which a qvd is loaded. Optimized is faster of course. But you may do no data_manipulation in the LOAD except renaming of fields with the AS option - otherwise it will not be optimized anymore. Apart from that, no need to worry about that.

Best regards,

DataNibbler

[vijetas42]

Hi Mahesh,

please check below link for more detail on optimized and un-optimized load,

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

whenever, u put some condition in qvd script to load restricted data based on some where conditions then it's called as un-optimized load.

Thanks,

Vijeta

[avinashelite]

Hi Mahesh,

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