topic Re: How to calculate Load time. in QlikView

How to calculate Load time.

Fri, 29 Nov 2013 11:26:07 GMT

Hi,

For performance point of view , i just want to know how to calculate load time of a Qvd. as data on Qvd grows day by day due to incremental load. load will help in predicting the time require in future to load a particular dashboard. Need advice.

Regards,

Piyush.

Re: How to calculate Load time.

Anonymous — Fri, 29 Nov 2013 11:29:27 GMT

Piyush

At the beginning of your script set a variable to the start time

let vstart = now() ;

Similar at the end

let vEnd = now() ;

Then you subtract End time form Start Time.

You may wish to use these values to populate a QVD and start building up a history.

Best Regards, Bill

Re: How to calculate Load time.

israrkhan — Fri, 29 Nov 2013 11:34:46 GMT

Hi,

I think you should do like in script,

if you create two variables in script, just before load statement, assign now() to variable,

Let vStartTime = Now();

load,

Then at the create another variable and assign now() to second variable,

and the on the front end, Variable2 - Variable2.....