Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

datanibbler
Esteemed Contributor

Calculate average LOAD_duration of an app loaded several times a day?


`Hi,

with the help of Shane from the Community I have just been able to write some good code to load, in a loop and one  by one, thus giving me detailes debug_info in the log, ten or eleven files.

Now I would like to apply the principle to another task:

- The background is, we need to get a plan of our entire reload_structure which is quite big and getting a bit unclear.

- So now I would like to calculate the average load_duration of an app which is loaded several times a day (virtually every one)

- I know I can use the >> directory << command to set a kind of standard - the directory Qlikview will use for any following LOAD.

- Using a SET command, I can set like a mask - all the folders in "DistributionService\1\log" have the word "production" in the name,

   so I write >> SET v_nameformat_applog = '*production*'; <<

- Then I can start a loop with the key command >> For each Dir in Dirlist('$(v_nameformat_applog') <<

- Inside that loop, I would like to load just the name

<=> Unfortunately, there is a structure of directories: Inside "DistributionService\1\Log", there is a directory for every day and inside those, there is a number of directories, one for every reload during that day - and it's in those that I need to look at the end of it.

That looping business somehow does not seem to work on directories - or I do not know what to put inside the LOAD_statement. I tried with FileBaseName(), but apparently that wasn't it.

I have already tried and found out how to load one single DocumentLog.txt - once I get that far down - and calculate the Load_Duration.

My idea is loading all the DocumentLogs from the same app from one day and calculating the average.

Tags (2)
5 Replies

Re: Calculate average LOAD_duration of an app loaded several times a day?

Maybe this approach could be helpful: Re: Auswertung - QlikView Enterprise Management Console

- Marcus

Not applicable

Re: Calculate average LOAD_duration of an app loaded several times a day?

Hi Data,

You might want to look at the potential of implementing audit logging for your applications. Can then look at reload times of individual sections of code within an application as well as the overall reload times and more.

Maybe have a read of this

http://community.qlik.com/docs/DOC-6187

Hope that helps

Joe

shane_spencer
Valued Contributor

Re: Calculate average LOAD_duration of an app loaded several times a day?

Look at this post: QlikView Performance Monitoring, specifically the QV_Reload-Log_processing.qvw to see if it can be altered to meet your needs. We had a very similar requirement for which I developed that.

datanibbler
Esteemed Contributor

Re: Calculate average LOAD_duration of an app loaded several times a day?

Hi Marcus,

but we don't have that - only the regular QMC - is there any difference at all, I'm not sure.

datanibbler
Esteemed Contributor

Re: Calculate average LOAD_duration of an app loaded several times a day?

Hi all,

thanks for all the helpful answers!

I guess that using any or all of this, I should be able to come up with something.

As yet, the avg. reload_time is not something we need as such though it does look very interesting for proper management of the QlikView_environment. I was thinking of this merely as one step in creating a sort of "time_plan" of our reload_structure to make it all more understandable and manageable.

So it might take a while until I actually get down to doing this, but then I'll need this code.

Thanks a lot!

Best regards,

DataNibbler

Community Browser