3 Replies Latest reply: Oct 23, 2013 7:33 AM by Michele Barini RSS

    CPU Usage

    Michele Barini

      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);