QlikView Load Times

[ncternal]

We have a requirement to capture the time it takes a QlikView file to load from file into memory.  What is the best method, if any, to do so?

I greatly appreciate any guidance you may have.

[sushil353]

enable the generate log file from doucument property>General>Generate Logfile

HTH

Sushil

[ncternal]

Thanks Sushil.  So this is only attainable at the document level and not the server level?

[#4]

with the help of log file get all details about your document.

for generate log file

->Setting

->doucument property

->General

->Generate Logfile

[Gysbert_Wassenaar]

At the top of the load script add

LET vStartTime = num(now());

At the end of the script add

LET vDuration = interval(now() - $(vStartTime),'mm:ss');

This will create a variable called vDuration with the script execution time formatted in minutes and seconds.

[#6]

Hi Gysbert,

I have millions of records to execute. Could I know the standard prodecure to estimate the time of proccessing??

Thanks

Pavan

[kamal_sanguri]

Thanks Gysbert,

This is something I was looking for I have had both the variables set in my application.

But, I was just subtracting Start Time with End Time and it was not working..

Something like this-

First statement of script: Let vExecutionStartTime = NOW();

Second Last statement of script: Let vExecutionEndTime = NOW();

Last statement : Let vTotalExecutionTime = vExecutionEndTime  - vExecutionStartTime ;

Wasn't aware of Interval ..!!