How to get time duration taken by a table to get reload

[chandni_popat]

Hi,

In QMC logs are getting generated for the QVW files when they are getting reloaded and from there we can see the reload time of a particular file. In my QVW file there are number of tabs to load different tables and I want to see reload time of each table instead of reload time of whole QVW file.

Please share your ideas or solution if it is feasible.I tried with TRACE function but somehow that does not met my requirement.

Thanks,

Chandni

[mohamed_ahid]

hi

normally i organise my script by section in every section i set a veriable with function now() , and when i finish the section i calculate the difference between now and the varibale .by this way i'm getting the reload time for this section .

i store this in a table with the name of the section .

you can use this for tables if you want also .

[maxgro]

LET vStart = Now(1);

load Rand() AutoGenerate 3000000;

LET vElapsed = interval(now(1) - '$(vStart)');

TRACE $(vElapsed);

[engishfaque]

Dear Chandni,

Kindly find attached App, I hope you are looking for that one.

Please note, you need to Load your tables in attached app.

Kind regards,

Ishfaque Ahmed

[chandni_popat]

Thanks Ishfaque for the solution.

just wanted to know if I will be able to see reload duration of each table in the logs of QMC as well, as we have reloads shceduled and we only check the logs of QMC for the status of the Reloads.

[chandni_popat]

Hi,

Can you please provide me any sample qwv files I just wanted to see that how these are loaded in a table.

Thanks!

[chandni_popat]

Hi Mohamed,

Sorry to bother you once again,can you please provide me the sample qvw files I just wanted to see that how these are loaded in a table.

Your help will be really appreciated.

Thanks!