topic Re: Optimized Load in QlikView

Optimized Load

prasadreddy — Mon, 19 Nov 2012 17:16:07 GMT

Hi any one can give me answer for Optimized load data in QVD?

Re: Optimized Load

Anonymous — Tue, 20 Nov 2012 01:23:37 GMT

When loading QVD files, if you don't make too many changes in the load statement, the table will be loaded in an optimized form. Some changes are ok, like changing field names, while other functionality will break the optimization and cause the table to be loaded slower.

Re: Optimized Load

jagan — Tue, 20 Nov 2012 07:12:55 GMT

Hi Prasad,

What Johannes said is absolutely correct, if you load a qvd without many changes then the data loads very faster. If we add any new fields, or modify any existing fields then loading would be bit slower. Check this URL hope it helps you.

http://community.qlik.com/message/71619#71619

Regards,

Jagan.

Re: Optimized Load

Tue, 20 Nov 2012 09:13:58 GMT

optimised load is faster

for this load we using change the name

doesnt use the expressions like where clause

Re: Optimized Load

prasadreddy — Tue, 20 Nov 2012 10:08:59 GMT

HI Jagan,

Thaks for clarifying my doubt about Optimized load,

Re: Optimized Load

prasadreddy — Tue, 20 Nov 2012 10:10:32 GMT

HI Johannes,

Thaks for clarifying my doubt about Optimized load,

Re: Optimized Load

prasadreddy — Tue, 20 Nov 2012 10:53:43 GMT

Hi Jagan

Can you please explain briefly how does QlikView storage data internally?

Re: Optimized Load

stevedark — Wed, 20 Feb 2013 23:58:50 GMT

Hi there,

I've just published a blog post on Optimized QVD loads that may make things a bit clearer:

http://bit.ly/YnAMqT

- Steve

http://www.quickintelligence.co.uk/