How to calculate Load time.

[#1]

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.

[Anonymous · Accepted solution]

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

[israrkhan]

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,

a,

b,

c

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

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