topic Re: Performance Tuning in Application Development and Automation Discussions

Performance Tuning

Former Member — Mon, 12 Jun 2006 12:30:13 GMT

Hi All

i am doing performance tunig for ALV Report

there is loop inside the loop has been used and there is nested performs.. Inside the loop n with in the performs..

How to do this

Regards

Chinna.T

Re: Performance Tuning

Former Member — Mon, 12 Jun 2006 12:34:24 GMT

Hi Chinna,

Use transactions SE30(Runtime analysis) and ST05(SQL Trace).Better to avoid LOOP in LOOPS.

Try to write READ statement inside inner LOOP for better performance.

RUNTIME ANALYSIS

The runtime analysis is an additional development workbench tool that is quite useful for analyzing performance of an ABAP / 4 Program or transaction. With this tool, the system can display information about:

• Executed instruction

• Accessed execution time.

• Tables and Types of access.

• Chronological execution flow

SQL TRACE

The SQL trace is a tool, which allows displaying and analyzing the contents for the database calls, which are made by the reports and transactions written in ABAP/4. It monitors programs and transactions on the database level. With the help of this facility for every open SQL instructions, you can display, about which SQL Embedded (DECLARE, OPEN, FETCH) Statement have been executed, besides analyzing the system performance.

Thanks,

Vinay

Re: Performance Tuning

former_member404244 — Mon, 12 Jun 2006 12:35:34 GMT

Hi chinna,

Goto SE30 and give ur program name and execute it.After that

analyse it.Will get the performance of ur program..

Take care while using nested loops....

Regards,

Nagaraj

Re: Performance Tuning

Former Member — Mon, 12 Jun 2006 12:35:54 GMT

Hi,

use read statement inside loop.

eg:

Loop at itab1 into wa_itab1.

read table itab2 into wa_itab2 where key1 = wa_itab1-key1.

endloop.

chk this link for more on performance tuning:

http://www.sapgenie.com/abap/performance.htm

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Re: Performance Tuning

vinod_gunaware2 — Mon, 12 Jun 2006 12:36:04 GMT

USE ST05 OR SE30

Authorisation trace analysis

1. Open two sessions

2. Execute transaction ST01 in one of the sessions

3. Select the authorisation checkbox, note the other traces

you can perform (SQL, RFC, Table Buffer etc)

4. Click the 'Trace On' button

5. Within your other session execte the transaction/report

you want to trace or get the user in question to do it

6. Return to the session where you turned the trace on and

click on 'Trace Off' otherwise it will continue to record all athorisation checks

7. Click on the 'Analysis' button

8. Enter appropriate data into selection screen such as

Username, type of trace records (i.e. Authorization check)

9. Click on the Execute button.

10. Report displaying trace results will now be displayed

*To turn runtim analysis on within ABAP code insert the following code

SET RUN TIME ANALYZER ON.

*To turn runtim analysis off within ABAP code insert the following code

SET RUN TIME ANALYZER OFF.

regards

vinod

Re: Performance Tuning

Former Member — Mon, 12 Jun 2006 14:15:36 GMT

For the nested loops, I wrote a <a href="/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops">blog</a>that may give you some ideas.

Rob