Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
how to set optimized qvd load and what are the drawbacks using it??
Thanks in Advance.
Regards,
Venkat.
Venkat,
See the attachment.
Thanks,
AS
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
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....
Hello.
By following this link, you will understand how optimize your qvd.
http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
Hi venkat,
Hope this will clear your doubt.
what is optimised load and unoptimised load with example ??
KR,
Naresh
Hi Venkat,
If its a large load then it will matter, else it will not make a difference.
thanks,
Rajesh Vaswani