topic Re: what is optimised load and unoptimised load with example ?? in QlikView

what is optimised load and unoptimised load with example ??

nikhilgarg — Mon, 22 Sep 2014 09:05:17 GMT

Hey,

Can anyone tell me what is optimised load and unoptimised load with example ??

THanx.

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

MK_QSL — Mon, 22 Sep 2014 09:14:28 GMT

Optimized and unoptimized QVD Load Situations? thanks in advance

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

jagan — Mon, 22 Sep 2014 09:23:02 GMT

Hi,

Check this thread

Optimized and Non Optimized loading

Regards,

Jagan.

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

nikhilgarg — Mon, 22 Sep 2014 09:31:59 GMT

HEy,

THe following message is coming when i click on the link:

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

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

nikhilgarg — Mon, 22 Sep 2014 09:32:53 GMT

Hey,

Thanks but i still did not get the idea what does this optimised and unoptimised deals with. Can you please explain breifly when load is optimised and when unoptimised ??

Thanks.

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

jagan — Mon, 22 Sep 2014 09:41:08 GMT

Hi,

This is the content in that thread

Hi,

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

Hope this helps.

Regards,

Jagan.

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

nikhilgarg — Mon, 22 Sep 2014 09:49:18 GMT

Hey,

Thanks. So should i assume that the cases that you have mentioned above are the only cases for Optimisation and Non optimisation ?? No other case except these will come under optimisation and non optimisation ??

THanks.

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

jagan — Mon, 22 Sep 2014 09:53:04 GMT

Hi,

I think Yes.

Regards,

Jagan.

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

nikhilgarg — Mon, 22 Sep 2014 09:58:11 GMT

Hey,

Can you also tell em when will be qvd load in standard mode ??

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

jagan — Mon, 22 Sep 2014 10:08:19 GMT

Hi,

If you are doing any transformations like calculations then it is in Standard mode.

Column1 * Column2 AS NewColumn1

Regards,

Jagan.

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

nikhilgarg — Mon, 22 Sep 2014 10:22:01 GMT

Oh ohk THanks.

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

jagan — Tue, 23 Sep 2014 01:03:08 GMT

Please close this thread so that it helps others to find solution.

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

nikhilgarg — Tue, 23 Sep 2014 04:55:15 GMT

heY,

yESTERDAY ONLY I MARKED YOUR ANSWER AS HELPFUL.

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

jagan — Tue, 23 Sep 2014 05:11:30 GMT

Hi Nikhil,

If you got the answer then close this thread by giving Correct Answer, giving correct answer will close this thread.

Regards,

Jagan.