Partial Reload - Can it improve performance?

[#1]

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!

[tresesco]

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

[rajeshvaswani77]

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

thanks,

Rajesh Vaswani

[deepakqlikview_123]

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

[#5]

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