topic Re: Program performance in Application Development and Automation Discussions

Program performance

Former Member — Wed, 19 Dec 2007 19:22:53 GMT

Hi,

I have a complex program that is going to multiple tables and hence the program is very very slow. How can i find out which select statement is taking the longest time?

Vartika.

Re: Program performance

Former Member — Wed, 19 Dec 2007 19:25:59 GMT

You can go to the transaction ST05.

ACtivate the trace and run your program and swith the trace off (ST05)

Then display the trace using ST05. It tells you what selec is taking too much time.

Regards,

Ravi Kanth Talagana

Re: Program performance

Former Member — Wed, 19 Dec 2007 19:27:59 GMT

SE30 is good for performance analysis. Run your program through that transaction.

Re: Program performance

Former Member — Wed, 19 Dec 2007 21:05:05 GMT

Okay, I ran it using SE30. I see the normal output displayed that I see when i run thr program in SE38. How do i do the analysis??

Re: Program performance

Former Member — Wed, 19 Dec 2007 21:34:06 GMT

Dear Vartika,

Transaction Code ST05 will take you to Perfomance Analysis, there you can make use of SQL Trace . It allows you to see how the OPEN SQL statements that you use in ABAP programs are converted to standard SQL statements ( and the parameters with which the embedded SQL statements are passed to the database system.

Best Regards,

Rajesh

Please reward points if found helpful.

Re: Program performance

Former Member — Wed, 19 Dec 2007 22:16:14 GMT

Hi Vartika

try ST04. Since you program access many tables, by runnings statistics for the table, the performance will increase

Cheers

~Arun

Re: Program performance

kiran_k8 — Thu, 20 Dec 2007 03:26:40 GMT

Vartika,

I guess you can even use SM50 to analyse where actually it is taking time to process the data.Run the program in se38 and then check in SM50.

K.Kiran.

Re: Program performance

Former Member — Thu, 20 Dec 2007 14:41:23 GMT

See the help files regarding SE30 for a full explanation.

The short version is this. All you really need to do is go to SE30 and execute your program from there. Once you get the output, green arrow back until you get back to SE30. Now you should be able to click the Evaluate button at the bottom. Once you get to the next screen, click the Hit List button for a full breakdown of where the time was spent. This will report selects, function calls, etc.

I usually prefer to sort it by the Net time, so I can see the big concerns right at the top. You can even get to the ABAP code by putting your cursor on a row and clicking the Display Source Code button.