CPU Usage

[bbi_mba_76]

Hello,

I would like to ask you about the CPU usage.

I have a report that load 2 qvd and concatenate them. I run the script on a server(virtual machine) with 2 CPU, and it took about 90% of CPU(with peak of 100%). We added 2 CPU to the same server and now the reload takes about 85%(max 95%).

Is this reasonable? Adding CPU there are not performance improvements?

These is the script:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';

$(Include=e:\reportqlik_config\config_file.txt);

LOAD * FROM $(PATH_QVD)Movimenti_FM.QVD (QVD)

where DATACOMP <= '20111231';

CONCATENATE

LOAD * FROM $(PATH_QVD)Movimenti_FM_2012.QVD (QVD);

[#2]

How is the load / performance when it comes to ram? High usage?

[rbecher]

It is reasonable because it's multi threaded. The overall processing time should be smaller then..

- Ralf

[bbi_mba_76]

@Andreas Klittbo the file is about 700M, the qv.exe takes about 1.3 G of RAM

@Ralf Becher the reload is about 4minutes with 4 CPU, 5minutes with 2 CPU