topic Loading issue from QVDs. in QlikView

Loading issue from QVDs.

Thu, 13 Sep 2012 05:26:01 GMT

is there any way to optimize the query below?

i have more than 2 millions records in the "EQUIPMENT_USES.QVD" when i try to load it without any where condition qlikview reloads it in 6 seconds but with where condition it is taking a long time to reload it.

i m aware with the fact that qlikview will execute it as an unoptimized statement but is there anyother way to fullfill my need with optimized load? or how can we optimize the query below?

LOAD GKEY AS CONTAINER_GKEY FROM (qvd)

WHERE ((CATEGORY = 'T' OR CATEGORY = 'I' OR CATEGORY = 'R') AND (IN_TIME > NUM(TODAY() - 60) AND IN_TIME < NUM(TODAY())))

AND

((CATEGORY = 'T' OR CATEGORY = 'E' OR CATEGORY = 'R') AND (OUT_TIME > NUM(TODAY() - 60) AND OUT_TIME < NUM(TODAY())));

Re: Loading issue from QVDs.

rajni_batra — Thu, 13 Sep 2012 05:38:17 GMT

WHERE (match(CATEGORY,'T', 'I', 'R') AND (IN_TIME > NUM(TODAY() - 60) AND IN_TIME < NUM(TODAY())))

( match(CATEGORY ,'T' , 'E' ,'R') AND (OUT_TIME > NUM(TODAY() - 60) AND OUT_TIME < NUM(TODAY())));

Re: Loading issue from QVDs.

Thu, 13 Sep 2012 06:19:28 GMT

Thanks for response but its still unoptimized

Re: Loading issue from QVDs.

chematos — Mon, 17 Sep 2012 20:09:53 GMT

I don´t think so, at the moment you use a condition, there will be an evaluation for each row of the table, I think is unavoidable.

Re: Loading issue from QVDs.

Tue, 18 Sep 2012 04:23:02 GMT

Is there any way to reduce reload time??

Because it is taking too much time to reload the document.

Re: Loading issue from QVDs.

Tue, 18 Sep 2012 06:34:44 GMT

Hi,

one way would be to load data from qvd file without condition and after that to load data with condition on resident table.