topic Unoptimized Load while implementing Section Access in QlikView

Unoptimized Load while implementing Section Access

Mon, 21 Sep 2015 10:53:43 GMT

While implementing Section Access by loading data from QVD, why do we need to do the load unoptimized?

Re: Unoptimized Load while implementing Section Access

Digvijay_Singh — Mon, 21 Sep 2015 12:17:24 GMT

Check this -

Re: Section Access Script load issue

Re: Unoptimized Load while implementing Section Access

marcus_sommer — Mon, 21 Sep 2015 12:50:36 GMT

An optimized load transferred the qvd with (nearly) no processing overhead directly into the RAM but some functionalities like section access needs some additionally processing step (in a kind of flagging which fields are used for them and maybe some more) - an optimized load instead will only load field-values and their pointer into the datamodel.

The solution is simple - see the link from above.

- Marcus

Re: Unoptimized Load while implementing Section Access

Tue, 22 Sep 2015 03:40:00 GMT

Thanks Digvijay for the prompt help

Re: Unoptimized Load while implementing Section Access

Tue, 22 Sep 2015 04:14:04 GMT

Thanks Marcus!! for the details.. that was indeed very helpful.

Re: Unoptimized Load while implementing Section Access

avinashelite — Tue, 22 Sep 2015 04:47:52 GMT

just to add a point, the optimized and un optimized load will have difference when your dealing with the huge data set, with a small data set may not see the difference. If you need the optimized load you can make all the necessary change before storing the data in QVD. Hope this might help you

Re: Unoptimized Load while implementing Section Access

Tue, 22 Sep 2015 04:58:03 GMT

Thanks Avinash. I had similar query 'If I do all transformation before storing the data in QVD, do I still require to do unoptimized load for section access'.. Thanks once again

Re: Unoptimized Load while implementing Section Access

avinashelite — Tue, 22 Sep 2015 05:04:46 GMT

No need of unoptimized load again, you can directly load the new data from QVD