topic optimized & unoptimized in QlikView

optimized & unoptimized

qlikview979 — Wed, 13 May 2015 09:37:38 GMT

Hi experts,

What is the script for optimized & unoptimized QVD ?

Re: optimized & unoptimized

rubenmarin — Wed, 13 May 2015 09:41:28 GMT

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;

Re: optimized & unoptimized

datanibbler — Wed, 13 May 2015 09:41:57 GMT

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

Re: optimized & unoptimized

vijetas42 — Wed, 13 May 2015 09:53:25 GMT

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

Re: optimized & unoptimized

avinashelite — Wed, 13 May 2015 10:05:58 GMT

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