Performance Tuning

[Former Member]

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

[Former Member]

Hi Chinna,

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

<b>Try to write READ statement inside inner LOOP for better performance.</b>

<b>RUNTIME ANALYSIS</b>

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

<b>SQL TRACE</b>

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<b></b>

[former_member404244]

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

[Former Member]

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.

<b>chk this link for more on performance tuning:</b>

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

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Message was edited by: Latheesh Kaduthara

[vinod_gunaware2]

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

[Former Member]

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