Performance Issue Tracking

[jchellap]

Qad version EE 2013

We have done many customization in our Qad with lot of ICT as well. I am checking the performance of a transaction CN-ISS. I Put the Progress 4GL trace to check the exact program which is taking more time but i could see hundreds of program which includes vanilla, customized ICT and trigger programs.

IS THERE ANY WAY TO CHECK WHICH IS THE PROGRAM IS CONSUMING MORE TIME?

Thanks in advance!!!

 

[Rob Fitzpatrick]

Depending on your Progress/OE version, you can use the profiler to determine which programs, and possibly even which lines of code, are taking the most execution time.

Be careful about doing this in production though, depending on what your code does it could accumulate a lot of profiling data very quickly. I've seen it write several gigabytes of profiling data in a few minutes for a busy client.

 

[jchellap]

Thanks for the info ! Could you please provide more details ?

 

[TheMadDBA]

This KB is related to WebSpeed but you can use the same basic logic/code to start a profiling session.. Progress KB - How to start the PROFILER from a WebSpeed application?

This KB tells you how to download the Profiler GUI (Windows) or if you are running on a version that has it included already... Progress KB - What is the Profiler Control Tool?

 

[Rob Fitzpatrick]

Sorry for the late follow-up. In addition to the above, profiling is now supported in 11.6 from PDSOE. There is a Profiler tab in the run configuration dialog that lets you set the options:


Once the session is done, you can view the profiling data from within PDSOE. Session summary:


Call tree: