Qlikview Script Load Very slow with Virtual server database

[aarshad67]

Hello there.

We are finding that when running a script data load using a SQL database sat on a virtual server, it runs very slow as opposed to running a script data load using a SQL database sat on a physical server.

For example :

1. QlikView SQL data load (3m+ records) on physical server with database also sat on physical server : 15 mins 8 secs load time
2. QlikView SQL data load (3m+ records) on virtual server but with database sat on physical server : 16 mins 34 secs load time
3. QlikView SQL data load (3m+ records) on virtual server with database also sat on virtual server  : 1 hour 9 mins load time

Just as an additional test, I ran SQL extracts on both the physical and virtual database servers

1. Physical Server : SQL Select ALL on 3m+ records table : 3 mins 12 seconds
2. Virtual Server : SQL Select ALL on 3m+ records table : 3 mins

FYI we are running QlikView version 11.

So it does seem to point to Qlikview as opposed to any network/resource issue. Would you agree ?

Is data load performance much slower with virtual server database as opposed to physical server database ?

If so, is there a workaround ?

Thanks in advance.

regards

Abdullah.

[petter]

It's hard to give much advise without more data:

• What is the memory and CPU configuration of all the different servers - virtual and physical?
• What is the size of the data extracted?
• How does the QlikView load script look like?

Virtual servers shouldn't affect performance in such a dramatic way as you experience unless the virtual server is significantly under-powered in respect to RAM and or CPU.

I wouldn't agree that the numbers suggest that you can rule out network/resource issue?