topic Re: why is loading a QVD file (optimized) slower on prod then on dev in QlikView

why is loading a QVD file (optimized) slower on prod then on dev

amien — Mon, 26 Jan 2026 18:19:17 GMT

I have a QVD file with contains about 10mil records. On development it loads in QMC within 25 seconds
(optimized). On Prod it will take more then 1 minute

Prod has more resource then Dev. Prod has 128GB of memory and 28 CPUs

Prod is a distrubution server only (accesspoint is on another server).

the QVD file is on the same location. So there should not be any network traffic between servers.

Virus scanner is off.

For could be the reason why development is faster then prod?

Thanks in advanced

Re: why is loading a QVD file (optimized) slower on prod then on dev

marcus_sommer — Fri, 27 May 2016 11:38:51 GMT

Yes, it seems strange. Maybe there are different configurations on the firewall / group policies. I think it would be helpful if you provide more details like the used OS + QV releases, the used hardware (Intel or AMD, ...), virtual or physically and so on.

- Marcus

Re: why is loading a QVD file (optimized) slower on prod then on dev

amien — Fri, 27 May 2016 11:46:16 GMT

Hi Marcus,

SR12 all servers

Windows Server 2008 R2 all servers

Dev is virtual, Prod is physical.

All Intel

I will check Prod, but on Dev Firewall is 3x off

Re: why is loading a QVD file (optimized) slower on prod then on dev

marcus_sommer — Fri, 27 May 2016 12:03:46 GMT

At least there is one difference (virtual/physical) between the servers but the impact from them should be rather reversed - so I think this will be rather not the reason.

The mentioned qvd is not very big so that a load of them should not touch the any hardware-resouces even if there are other processes / tasks running. But to exclude anything like that and that the whole windows environment had any problem - could you repeat this after a restart from the qlikview services respectively the OS.

- Marcus

Re: why is loading a QVD file (optimized) slower on prod then on dev

swuehl — Fri, 27 May 2016 12:05:39 GMT

Have you measured the drive throughput and ressource occupation on both systems?

Re: why is loading a QVD file (optimized) slower on prod then on dev

Peter_Cammaert — Fri, 27 May 2016 12:13:25 GMT

Maybe RAM exhaustion? You say that the AccessPoint is on another server, but the AP is just a web site which poses almost no load on a server machine (RAM or CPU). Where is your QVS located? On a separate machine as well?

Maybe I/O channel differences? The production machine may have a slower I/O channel (disks and such) than the virtual server. The hardware on which virtual machines are configured is usually highly parallelized with lots of high-speed memory and extremely fast disks (because of having the reponsibility to run multiple virtual machines with acceptable performance at the same time). It's difficult to compare virtual machines with real physical machines.

Peter

Re: why is loading a QVD file (optimized) slower on prod then on dev

amien — Fri, 27 May 2016 12:48:55 GMT

i'v checked the drive throughput, using performance monitor (i guess this is what you mean). The disk performance (k/sec) is much lower on prod. all the files are on E: i assume this is also not a network location. How can i check this? it's not mapped or something like this.

Re: why is loading a QVD file (optimized) slower on prod then on dev

amien — Fri, 27 May 2016 12:50:03 GMT

QVS is on a difference server. only QDS runs on this server.

Re: why is loading a QVD file (optimized) slower on prod then on dev

swuehl — Fri, 27 May 2016 12:57:25 GMT

Open the Microsoft Management Console (start > run > mmc) and load in the Disk Management snap-in. This will show you show you which drive letters are assigned to which disks and you can check the disk properties (right click > properties) to see the vendor / details.