This content has been marked as final. Show 3 replies
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 MoneyFormat='€ #.##0,00;-€ #.##0,00';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
LOAD * FROM $(PATH_QVD)Movimenti_FM.QVD (QVD)
where DATACOMP <= '20111231';
LOAD * FROM $(PATH_QVD)Movimenti_FM_2012.QVD (QVD);