topic Re: Partial Reload - Can it improve performance? in QlikView

Partial Reload - Can it improve performance?

Tue, 02 Sep 2014 11:19:15 GMT

Hi,

I need to find out if Partial Reload is a performance improvement compared with that to a typical Reload. I have a set of QVD's which fetch over 10 million records and it was suggested that using partial reload instead of the normal reload would improve the loading times. I haven't done this but before doing it I would like some expert suggestions.

Thanks!

Re: Partial Reload - Can it improve performance?

tresB — Tue, 02 Sep 2014 11:25:37 GMT

Explore one more option along with this partial reload, called incremental load. Depending on your requirement and proper implementation, both can improve performance.

Re: Partial Reload - Can it improve performance?

rajeshvaswani77 — Tue, 02 Sep 2014 11:29:29 GMT

You will need to identify table wise a guaranteed primary key field as well as a last modified date time stamp.

thanks,

Rajesh Vaswani

Re: Partial Reload - Can it improve performance?

deepakqlikview_123 — Tue, 02 Sep 2014 11:58:37 GMT

Hi,

Partial load is nothing but add and replace load.It can definitely improve the performance.

But as per tresesco's suggetion you can please explore other option like incremental load.

Thanks

Re: Partial Reload - Can it improve performance?

Wed, 03 Sep 2014 13:36:34 GMT

Thanks tresesco, Rajesh and deepak. I will look at the suggestions given you all and check on the situation.