topic qlikview task reload time in QlikView

qlikview task reload time

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: qlikview task reload time

Miguel_Angel_Baeyens — Tue, 11 Apr 2017 08:50:27 GMT

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?)

Re: qlikview task reload time

stonecold111 — Tue, 11 Apr 2017 09:20:03 GMT

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

Re: qlikview task reload time

stonecold111 — Tue, 11 Apr 2017 09:25:43 GMT

Am i right???

Re: qlikview task reload time

Miguel_Angel_Baeyens — Tue, 11 Apr 2017 10:54:51 GMT

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.

Re: qlikview task reload time

stonecold111 — Tue, 11 Apr 2017 11:12:12 GMT

thanks for ur time