performance

[#1]

Hello

By idea of Rob I make very simple qvw document:

Load Recno( ) as A, Rand() as B autogenerate(10000000);

Reload on my local notebook is about 25 sec long.

Reload on our huge servers is about 46 sec long ! (servers are iddling before starting reload).

Offer:

Can other users respond how long is reloading this simple qvw on yours servers ?

Thanks

[#2]

Same thing here :

- My laptop is Core 2 Duo @ 2.33 GHz with 2 Gb of RAM (Windows XP) : 24 seconds to reload (QV 9 SR 6).

- My client server has 16 cores with 32 Gb of RAM (Windows 2008 Server SP 2) : 36 seconds to reload (QVS 9 SR 6).

I tried to disable hyperthreading, that makes the process slightly slower.

[#3]

To make a fair comparison, set your idle server to use only 2 out of 16 cores with affinity mask = 00000001 00000001 (binary) = 0101 (hexa)

Schedule a batch file OR type every now an than during the testing in PowerShell

powershell -command "& { get-process qvb | foreach{ $_.processoraffinity=0x0101} }"

-Alex

[#4]

QV server does logging, job scheduling etc. 12 seconds overhead to a 30 seconds job is just noise.

Problem is when reload takes four hours in laptop, and eight hours in server.

-Alex

[pover]

Alex has a good point about 12 seconds being noise, so what would happen if nmartin adds a couple zeros to the autogenerate?

Regards.

[prieper]

On my notebook (2*2.4GHz Processors): 26s
On the server (8*2.5Ghz): 28s, but some other processes running in parallel

Peter

[#7]

Hello

Reload process is single core (single CPU) ?

in version 10 it is running connect64 process and qvb process.

Newer see 100% CPU using when reloading.