topic extremly long upload time in QlikView

extremly long upload time

Sun, 04 Oct 2015 19:42:37 GMT

Hi,

When refreshing the data from the company, it takes ~30 seconds, when doing this from home, being connected to the company servers, it takes 3 hours!!!

It is not due to network - I can work on the files placed on my company server with only slight or no delay...

where should I look for the root cause?

Thanks

Draszor

Re: extremly long upload time

qlikviewwizard — Sun, 04 Oct 2015 23:49:33 GMT

How many columns if the tables?

Are they required all those columns? Are you pulling unnecessary data without filtering?

For example:

SELECT C1,C4,C8 from Table1 where Year>=2014 instead of SELECT * FROM Table1 where Year>=2014

Hope this will help you.

Re: extremly long upload time

SreeniJD — Mon, 05 Oct 2015 04:22:27 GMT

If you are working on company servers through VMware or something else, this shouldn't be major challenge.

What I can suggest you is, just try to limit your load for one table and see, whether you are still taking lot of time to load the data. If it is taking lot of data, it means its the problem with RAM on your virtual machine.

HTH

Sreeni