topic Re: optimised qvd load in QlikView

optimised qvd load

Anonymous — Fri, 05 Dec 2014 10:34:40 GMT

Hi folks,

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

Thanks in Advance.

Regards,

Venkat.

Re: optimised qvd load

amit_saini — Fri, 05 Dec 2014 10:37:09 GMT

Venkat,

See the attachment.

Thanks,

Re: optimised qvd load

amit_saini — Fri, 05 Dec 2014 10:42:37 GMT

Also check this:

QVD Optimized

Thanks,

Re: optimised qvd load

rajeshvaswani77 — Fri, 05 Dec 2014 10:47:31 GMT

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

Re: optimised qvd load

Anonymous — Fri, 05 Dec 2014 10:51:44 GMT

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....

Re: optimised qvd load

yduval75 — Fri, 05 Dec 2014 10:53:16 GMT

Hello.

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

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

Re: optimised qvd load

narband2778 — Fri, 05 Dec 2014 10:56:40 GMT

Hi venkat,

Hope this will clear your doubt.

what is optimised load and unoptimised load with example ??

KR,

Naresh

Re: optimised qvd load

rajeshvaswani77 — Fri, 05 Dec 2014 11:02:14 GMT

Hi Venkat,

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

thanks,

Rajesh Vaswani