topic Re: optimized load in QlikView

optimized load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

HI Experts,

1. I have 1 gb qvd in that qvd i want to load only specific data by using where clause but if i use the where clause that is the nonoptimized load but i want load the specific data from qvd by using optimized load how?

2. in section if i put * means access for all but if i leave space Instead of * then what is the meaning of Space ?

Please help me the same

Re: optimized load

jubarrosor — Wed, 04 Jul 2018 06:13:31 GMT

Hi padma:

The only acceptable filter is using function Exists:

WHERE Exists(Field)

optimize and non-optimze load in qvd

Best Regards,

Juan P. Barroso

Re: optimized load

qlikviewwizard — Wed, 04 Jul 2018 06:22:36 GMT

Hope this will help.

Select only required fields and use where condition or Exits(If the field already loaded into RAM).

Hope this will help you.

//Method1:

OneGBQvd:

LOAD Country,

[Ops Type],

[SLA Target],

Month_Temp,

Ops_Errors

FROM

[..\QVD\OneGBQvd.qvd]

(qvd)

where Exists(Country);

//Method2:

OneGBQvd:

LOAD Country,

[Ops Type],

[SLA Target],

Month_Temp,

Ops_Errors

FROM

[..\QVD\OneGBQvd.qvd]

(qvd)

where Country='Country1' AND YEAR>='2016';

Re: optimized load

Miguel_Angel_Baeyens — Wed, 04 Jul 2018 06:30:53 GMT

"In section" you mean section access? If so, the * is used to refer to all the existing values for that column in the section access table, not in the data model. The space is used to leave developers (using QlikView Desktop) or service accounts (in QlikView servers) to see all values in that field, regardless how many of them have been listed or even if none has been listed.

Re: optimized load

Anonymous — Wed, 04 Jul 2018 06:33:39 GMT

Thanks for the reply

as per the second method your were using the where condition so it is non optimized ?

If yes the same now my question is i want load same filters with optimized load.

Thanks

Re: optimized load

qlikviewwizard — Wed, 04 Jul 2018 06:39:46 GMT

Hi Hope this will help you.

Optimized / non optimized refers to the load of qvd, not to the file

Optimized is (usually) faster

When you reload you can see in the script execution progress window if the load is optimized

testqvd 10.000.000 lines fetched

testqvd (qvd optimized) 10.000.000 lines fetched

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

(thanks to Steve Dark)

Some examples of things that will cause a non-optimised load are:

- Adding new fields to the table
– Deriving new values from a field in the QVD
– Retrieving a field twice
– Most WHERE conditions
– Joining to an existing in memory table
– Loading data into a mapping table

In contrast the things you are allowed to do are:

- Rename fields

– Omit fields
– Do a simple one field WHERE EXISTS on a field returned in the record set

Re: what is optimised load and unoptimised load with example ??

What is optimised QVD?

QlikTip#: Keep Optimized QVD Load

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