Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

qlikview task reload time

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

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: qlikview task reload time

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

View solution in original post

5 Replies
Highlighted

Re: qlikview task reload time

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

View solution in original post

Highlighted
Creator III
Creator III

Re: qlikview task reload time

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

Highlighted
Creator III
Creator III

Re: qlikview task reload time

Am i right???

Highlighted

Re: qlikview task reload time

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.

Highlighted
Creator III
Creator III

Re: qlikview task reload time

thanks for ur time