Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nvrphanikumar
New Contributor III

Log run times in DataLoad Editor

Hi,

Currently ,My process runs for about 2 hours and I would like to know which steps is taking longer to run.

tried an approach below ,where I declare a variable and then Output that variable as soon as the step is completed.But couldn't get it to work.

LET StartOfScript = Now();

Table_A:

LOAD

*

FROM [lib://QVDS/TABLE_A.qvd](qvd) ;

$(StartOfScript) ;

1 Solution

Accepted Solutions
MVP
MVP

Re: Log run times in DataLoad Editor

LET Start = Now();

//SLEEP 1000;

Table_A: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

//SLEEP 3000;

Table_B: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

2 Replies
MVP
MVP

Re: Log run times in DataLoad Editor

LET Start = Now();

//SLEEP 1000;

Table_A: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

//SLEEP 3000;

Table_B: LOAD * ...... ;

LET Elapsed = interval(Now() - '$(Start)');

Trace $(Elapsed);

LET Start = Now();

nvrphanikumar
New Contributor III

Re: Log run times in DataLoad Editor

Thanks You...Trace did the trick