performence

Former Member — Sat, 19 May 2007 11:33:45 GMT

how to care performance ?

Re: performence

Former Member — Sat, 19 May 2007 11:40:42 GMT

See the ST05 Transaction and SE30 Transaction..

if it is custom program then use

data : f1 type i,

f2 type i,

f3 type i.

data : i_mara like mara occurs 0 with header line.

get run time field f1.

select * from mara into table i_mara.

get run time field f2.

f3 = f2 - f1.

write : f3.

Reward Points if it is helpful

Thanks

Seshu

Re: performence

Former Member — Sun, 20 May 2007 09:55:31 GMT

ST05 and SE30 are the transaction codes used to check the performance .

ST05 is the transaction for SQL trace.

SE30 is the transaction for runtime analysis.

by executing any of these transactions u will come to know how much time its taking for execution.

depending on the analysis u have to change your program for better performance by avoiding neseted SELECT statements,use databsae views instead of using database tables,use binary search while reading internal tables avoid SELECT DISTINCT and order by .

award points if useful.

sagarika.k

Re: performence

Former Member — Mon, 21 May 2007 04:20:58 GMT

Hi,

1. Generally, ABAP perfroimance can be improved by reducing load on database and can be shared by ABAP. system is generally contant. And DB performance can be improved with effient SQL statements. This is most important.

2. Simply refer 'Tips and ticks' section of SE30 i.e. Performance tuning, here u will get tips with egs.

3. Run ur program in SE30 u will get report with graph (DB, ABAP and system %) analyse that report, and try to implement it in ur prg.

4. Also refer ST05.

Jogdand M B

Re: performence

Former Member — Mon, 21 May 2007 09:18:15 GMT

hi,

ABAP performance depends upon various factors and in devicded in three parts:

1. Database

2. ABAP

3. System

Run Any program using SE30 (performance analys) to improve performance refer to tips and trics section of SE30, Always remember that ABAP perfirmance is improved when there is least load on Database.

u can get an interactive grap in SE30 regarding this with a file.

also if u find runtime of parts of codes then use :

Switch on RTA Dynamically within ABAP Code

*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.

Always check the driver internal tables is not empty, while using FOR ALL ENTRIES

Avoid for all entries in JOINS

Try to avoid joins and use FOR ALL ENTRIES.

Try to restrict the joins to 1 level only ie only for tables

Avoid using Select *.