topic Re: QlikView Load Times in QlikView

QlikView Load Times

ncternal — Wed, 29 May 2013 12:00:32 GMT

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 — Wed, 29 May 2013 12:02:59 GMT

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

HTH

Sushil

ncternal — Wed, 29 May 2013 12:35:01 GMT

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

Wed, 29 May 2013 12:48:42 GMT

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

for generate log file

->Setting

->doucument property

->General

->Generate Logfile

Gysbert_Wassenaar — Wed, 29 May 2013 12:54:59 GMT

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.

Thu, 16 Oct 2014 10:16:45 GMT

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 — Wed, 14 Oct 2015 10:25:26 GMT

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 ..!!