Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rob_insley
New Contributor III

Best Practice for Implementing Incremental Reload.

I am supporting an implementation of Qlikview where the End Application contains a Load Script which uploads Incremental data to the data model.  The reload schedule of this document is every 20 minutes and the load scripts takes between 9-11 minutes to complete.

When the reload schedule is running then the performance the users experience is considerably worse than when it is not running.  Is there an established best practice in terms of :

a) Incremental Reload methodology when reloading a document accessed by users

b) Document Settings

c) Server settings

that would minimise the impact of high frequency reloads on end user performance.

Any advise or  pointers gratefully received.

Thanks

6 Replies
rob_insley
New Contributor III

Re: Best Practice for Implementing Incremental Reload.

I should add that there is no Publisher Server in this solution, only Qlikview Server and all processes are running on a single server.


Re: Best Practice for Implementing Incremental Reload.

Hi,

Check this for better understanding.

Regards

ASHFAQ

amit_saini
Honored Contributor III

Re: Best Practice for Implementing Incremental Reload.

Rob,

Please see the attachments.

Thanks,

AS

sakamsureshbabu
Contributor

Re: Best Practice for Implementing Incremental Reload.

i have this same problem

vardhancse
Valued Contributor II

Re: Best Practice for Implementing Incremental Reload.

Convert the data in to QVD, so that for every dashboard maintain one QVD geerator app and one main dashboard file.

So that while QVD generetor was running there will be no impact for dashboard to uses.

Once QVD generator was completed then we can reload main dashboard file.

sakamsureshbabu
Contributor

Re: Best Practice for Implementing Incremental Reload.

thanks

Community Browser