Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Scheduled Reload 50% slower than manual reload

Hello community

Help please.

We have scheduled several reports and dashboards, mostly they run without issue.The bulk of them refresh over night when business is a lot quieter, others several times over a 24 hour span.

One particular QVD building model has become a lot slower over the past month. It has now gone over 65% slower for no apparent reason. When the refresh is undertook manually it is a lot quicker. What is also perplexing is that at the time the model runs (per schedule ), there are no other processes at work.

We do not use incremental reload as this may not update corrections done from the source data.

Any advice would be most welcome.

re

Paw

4 Replies
Highlighted
MVP
MVP

Re: Scheduled Reload 50% slower than manual reload

Are you sure that there is no process (backup, AV scan, DB maintenance tasks ...) that now runs at the same time as the scheduled load that is affecting the rate of data transfer. The manual load is done at another time and is not affected.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

Re: Scheduled Reload 50% slower than manual reload

Also, check that it's not been held up by another reload around the same time

Andy

Highlighted
Not applicable

Re: Scheduled Reload 50% slower than manual reload

No, no other reload is happening at that time.

& the source data etl is usually completed and ready when this task commences

I have inquired with the rest of business on any other DB processes and or changes may have been implemented in the past month  that could be a factor. Hopefully there will be something that once sorted all will be well.

Highlighted

Re: Scheduled Reload 50% slower than manual reload

A reload executed by the Distribution Service uses memory on top of what the QlikView server has allocated for itself. The two services do not share any memory, and the distribution service may slow down to a crawl if there isn't enough RAM available to load all data in memory (paging and stuff)

Did you monitor memory usage at the time of the (slow) reload? Has the amount of processed data grown over the past month? Have you ever tried restarting the QlikView Server service (just that one) just before the reloads are initiated, so that the QlikView Server service releases all allocated memory which the Distribution Service can use for reloading?

Peter