Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
enable the generate log file from doucument property>General>Generate Logfile
HTH
Sushil
Thanks Sushil. So this is only attainable at the document level and not the server level?
with the help of log file get all details about your document.
for generate log file
->Setting
->doucument property
->General
->Generate Logfile
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.
Hi Gysbert,
I have millions of records to execute. Could I know the standard prodecure to estimate the time of proccessing??
Thanks
Pavan
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 ..!!