topic ETL performance question: Why 1core cpu works? in QlikView

ETL performance question: Why 1core cpu works?

Wed, 27 Apr 2011 08:57:12 GMT

HI,

I set up a windows2003 64bit server with 8G ram and 4 core intel cpu.

And I have a 10,000,000 records table which needs to etl from an oracle server.

I notice the cpu 's usage is 23%, 1 core is working while others are idle.

The attachment is the pic of the server performance.

Can I use the other core?

ETL performance question: Why 1core cpu works?

rbecher — Wed, 27 Apr 2011 10:00:56 GMT

Hi,

this is the behavior of version 9. Since version 10 the use of multiple cores during load is included.

- Ralf

ETL performance question: Why 1core cpu works?

Wed, 27 Apr 2011 13:48:12 GMT

Hi Ralf, Thanks for your reply. Could you please tell me: if I load data into QVD file with V10, can I load the QVD file into QVW which created by V9?

Thank you again:)

ETL performance question: Why 1core cpu works?

rbecher — Wed, 27 Apr 2011 13:51:36 GMT

Hi,

I haven't tried yet but I would presume this will be no problem.

- Ralf