qlikview task reload time

[stonecold111]

Hi qlikkss

i have a task in QMC scheduled at 1 AM

task reload times

.

.

.

4/7/2017  11 min

4/8/2017 1 hr 3 sec

4/9/2017 12 min 13 sec

4/9/2017 1 hr 5 min 33 sec

in alternate days it is taking more than 1 hour

its continuing like this from 1 month

what could be possible reasons  for different timings on alternate days

Suggest me

[Miguel_Angel_Baeyens · Accepted solution]

Main reasons for me are

• the difference in the number of rows to be extracted
• speed of the database or source
• concurrency of other services running and using resources at the same time that QlikView reloads

Also, network usage if loading from a remote server, processes using disk (like backup or antivirus) while the files are stored, processes on the database (reindexing, cleanup, etc.) would also affect this way.

You will need to set the log to the highest verbosity and see which step takes longer (i.e.: is it reloading itself? is it saving files time? Connecting?)

[stonecold111]

actually it is because of the buffer load i think

we have buffer load stale after 1 day

so for the next day its taking from source db not qvd

[stonecold111]

Am i right???

[Miguel_Angel_Baeyens]

Yes, so the above still applies. If your source is slower, or has more rows to update from, the process will take longer.

I have to mention that I very seldom used buffer load, and it has been a long while since (version 10 and earlier) so I cannot offer you any good advice for speeding up buffer loads.

[stonecold111]

thanks for ur time