optimised qvd load

[Anonymous]

Hi folks,

how to set optimized qvd load and what are the drawbacks using it??

Thanks in Advance.

Regards,

Venkat.

[amit_saini]

Venkat,

See the attachment.

Thanks,

AS

[amit_saini]

Also check this:

QVD Optimized

Thanks,

AS

[rajeshvaswani77]

Hi Venkat,

Optimized load is suppose to be faster than a non optimized load. (I suppose its 10 times faster)

This is useful for large recordsets.

There is suppose to be no where clause for the load statement that must have optimized load.

When the load is optimized it will show optimized in brackets, when its reloading.

Only acceptable where condition you can use is where exists(fieldname) in the where clause.

anything else used will make it unoptimized.

thanks,

Rajesh Vaswani

[Anonymous]

Thanks Rajesh i got it....  do we set optimized or unoptimized  qvd else depending on where clause we call like that??? sorry if my question makes no sense....

[yduval75]

Hello.

By following this link, you will understand how optimize your qvd.

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

[narband2778]

Hi venkat,

Hope this will clear your doubt.

what is optimised load and unoptimised load with example ??

KR,

Naresh

[rajeshvaswani77]

Hi Venkat,

If its a large load then it will matter, else it will not make a difference.

thanks,

Rajesh Vaswani