extremly long upload time - Qlik Community

Report Inappropriate Content · ‎2015-10-04

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

qlikviewwizard · ‎2015-10-04

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.

SreeniJD · ‎2015-10-05

Hi

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