topic Re: QVD load not optimized when used Exists function in QlikView

QVD load not optimized when used Exists function

manishnarang — Fri, 09 Oct 2015 12:17:12 GMT

Hi,

I have a QVD of around 60M rows. I am trying to load the dates for a particular type of products.

Sample script:

------------------------------------------

Temp:

Load * Inline

[

Product Type

];

LoadDates:

Load [Invoice Date]

from

abc.qvd(qvd)

where

exists([Product Type]);

Drop table Temp;

-------------------------------------

It gives me the data for Product Type A, B and C, but takes very long time to execute and in Trace window, it does not show as Optimized Load.

without this filter, I am able to load the dates in 1/10th time of the time taken to load the above.

Can anyone help what i am missing?

Regards,

Manish

Re: QVD load not optimized when used Exists function

tresB — Fri, 09 Oct 2015 12:32:50 GMT

The script you shared seems to be a sample one. Could you share the exact load statement you are trying?

Re: QVD load not optimized when used Exists function

manishnarang — Fri, 09 Oct 2015 12:43:58 GMT

appriciate your response but

I won't be able to share the exact script but this is exactly the same logic i am using.

Re: QVD load not optimized when used Exists function

tresB — Fri, 09 Oct 2015 12:54:40 GMT

Not even that exact load section of the script?

Re: QVD load not optimized when used Exists function

sasiparupudi1 — Fri, 09 Oct 2015 13:00:33 GMT

Are you selecting Product Type from your qvd?

Re: QVD load not optimized when used Exists function

manishnarang — Fri, 09 Oct 2015 13:04:16 GMT

Thanks again. This is,in fact, the exact same script except column names changed..

Re: QVD load not optimized when used Exists function

manishnarang — Fri, 09 Oct 2015 13:05:16 GMT

Hi,

No, Just loading the dates.

Product Type is in where clause only.

Re: QVD load not optimized when used Exists function

tresB — Fri, 09 Oct 2015 13:13:50 GMT

Try including the comparative field [Product Type] in the load (and then drop), like:

LoadDates:

Load

[Invoice Date],

[Product Type]

from

abc.qvd(qvd)

where

exists([Product Type]);

Drop Field [Product Type];

Re: QVD load not optimized when used Exists function

manishnarang — Fri, 09 Oct 2015 13:20:42 GMT

Thank you very much. It worked perfectly.