optimized load

[Anonymous]

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

[jubarrosor]

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

[qlikviewwizard]

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';

[Miguel_Angel_Baeyens]

"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.

[Anonymous]

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

[qlikviewwizard]

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/