topic what are optimized loads and unoptimized loads ? in QlikView

what are optimized loads and unoptimized loads ?

nikhilgarg — Sat, 27 Jun 2015 09:30:22 GMT

Hello,

Can anyone help me out by telling what are optimized loads and unoptimized loads ?

Thanks

Re: what are optimized loads and unoptimized loads ?

Siva_Sankar — Sat, 27 Jun 2015 10:38:48 GMT

QVD files can be read in two modes: standard (fast) and optimized (faster). The selected mode is determined automatically by the QlikView script engine. Optimized mode can be utilized only when all loaded fields are read without any transformations (formulas acting upon the fields), though the renaming of fields is allowed. A WHERE clause causing QlikView to unpack the records will also disable the optimized load.

1)F1 as NewField - Renaming allowed, so it is optimized load

Ex:

LOAD

Field1 AS Date,

Field2 AS Sales

FROM DataSource;

2)F1 * 2 as NewField – Transformation is not allowed, so it is non optimized load

Ex:

LOAD

Field1 AS Date,

Field2 AS Sales,

Discount,

Field2 - Discount AS NetSales // This is a transformation

FROM DataSource;

3)1 as NewField – Cannot add a new field, so it is non optimized load

LOAD

Field1 AS Date,

Field2 AS Sales,

1 AS Flag // Adding new field

FROM DataSource;

4)WHERE Exists(F1) – We can use Single Field in Exists(), so it is an Optimized load

LOAD

Field1 AS Date,

Field2 AS Sales

FROM DataSource

WHERE Exists(Field1);

5)where exists(F1, Some Transformation) – We cannot use Multiple Field in Exists(), so it is a non Optimized load

LOAD

FirstName,

LastName,

Sales

FROM DataSource

WHERE Exists(Field1, FirstName& ' ' &LastName);

Re: what are optimized loads and unoptimized loads ?

Siva_Sankar — Sat, 27 Jun 2015 10:39:22 GMT

Also, refer here Turning Unoptimized Loads into Optimized Loads

Re: what are optimized loads and unoptimized loads ?

Siva_Sankar — Sat, 27 Jun 2015 12:51:16 GMT

In simple words,

Optimized loads are faster and preferable for large data.

The term optimized load means, if no calculations are made during loading and no filters in a WHERE CLAUSE.

The only possible filter condition is: WHERE Exists(Field)

Optimized Load:

Load * From Table

WHERE EXISTS(Department);

Unoptimized Load:

Load * From Table

WHERE Department = 'SALES'

Re: what are optimized loads and unoptimized loads ?

nikhilgarg — Sat, 27 Jun 2015 12:58:38 GMT

Thanks shankarece,

It helped me. So, by your reply, i assume that if no transformations applied while loading the datafrom QVD, then it will be an optimized load else unoptimized load.

Re: what are optimized loads and unoptimized loads ?

Siva_Sankar — Sat, 27 Jun 2015 13:15:54 GMT

Yes Nikhil,

Except renaming and WHERE Exists(onefield) is allowed in optimized load.

Re: what are optimized loads and unoptimized loads ?

PanguiCat — Wed, 12 Oct 2022 19:00:55 GMT

A trick i have been using is to load QVD without transformation as tem table then i load table with transformations i need with Resident.