Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Local reload takes less time as compared to reload via QMC

Hi,

I wanted to know if someone has experienced this behavior, where reloading a task locally takes less time as compared to reloading the task via QMC.

Regards,

Janaki

7 Replies
sebastiandperei
Specialist
Specialist

The task via QMC works in background

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's quite possible, and even common, for a desktop reload to run faster than a QMC reload. Possible reasons:

1. Faster I/O.

2. Faster CPUs

-Rob

Not applicable
Author

Hi Rob,

The same task when I run at our lower environment via QMC (UAT) it runs same as the desktop reload on Prod, which seems a bit confusing to me.

Regards,

Janaki

mithilesh17
Partner - Creator II
Partner - Creator II

Hi,

One possible case is that other concurrent task/s scheduled in QMC at that particular reload which consumes CPU, hence more time as compare to local.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

One of many reasons for unexpected (inferior) performance may be that on your UAT machine QVS isn't claiming any substantial amount of memory, leaving a larger chunk to the QVB process. While on your production machine, many users have many documents open (causing QVS to theoretically run off with as much as 90% of system memory), leaving not enough memory to do a reload entirely in RAM... As soon as the QVB process starts trashing, performance goes south...

You will probably understand that there is no one-fits-all answer to this question. As Rob already indicated, it depends on machinery and circumstances: available cores, available RAM, memory speed, processor speed, I/O channel bandwidth, number of processes, I/O load, CPU load, etc.  Task manager may offer you your first view on possible reasons for sub-optimal performance.

Best,

Peter

Not applicable
Author

I have made changes to the task to run the first thing in the morning when nothing else is running. Hopefully I will know if it finishes or runs for long time.

maxgro
MVP
MVP

You can compare the server document log with local document log and see if the time differences are on particular statement (which ones?) or all (in this case it should be a problem of server resources).