Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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())));
WHERE (match(CATEGORY,'T', 'I', 'R') AND (IN_TIME > NUM(TODAY() - 60) AND IN_TIME < NUM(TODAY())))
OR
( match(CATEGORY ,'T' , 'E' ,'R') AND (OUT_TIME > NUM(TODAY() - 60) AND OUT_TIME < NUM(TODAY())));
Thanks for response but its still unoptimized
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.
Is there any way to reduce reload time??
Because it is taking too much time to reload the document.
Hi,
one way would be to load data from qvd file without condition and after that to load data with condition on resident table.