Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
Alex has a good point about 12 seconds being noise, so what would happen if nmartin adds a couple zeros to the autogenerate?
Regards.
On my notebook (2*2.4GHz Processors): 26s
On the server (8*2.5Ghz): 28s, but some other processes running in parallel
Peter
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.