How to increase the performance of a program

[Former Member]

How to increase the performance of a program.

Regards

Lisa

Message was edited by: Lisa Roy

[Former Member]

Lisa,

Is your problem solved.

If solved then close this discussion and award points to all useful answers.

Thanks,

Ramesh.

[Former Member]

Hi,

one of the steps would be to reduce the no. of hits to database to a minimum..

it would be better to search an internal table after sorting and using binary search...

it mainly depends on the program...can we have more details to recommend few steps

regards

Sai easwar

[Former Member]

Check the SQL Trace using transaction ST05. This will give runtime details for the code executed and help to check for eg which SELECT is taking more execution time.

Also do runtime analysis of program using SE30. Here in this transaction if you follow path Utilities --> Tip & Tricks, it will give basic tips in ABAP programming.

[Former Member]

In se30 transaction if you go to Utilities menu

in that TIPS and TRICKS

there you can see some samples to increase the performance of program...

vijay

[RichHeilman]

You will get you best performance boost by looking at your SELECT statements. You will want to hit the DB as little times as possible.

Regards,

Rich Heilman

[Former Member]

Hi,

Performance tuning is big topic. It is not possible to suugest here. Refer to help on ABAP Programming. There you can find many points. If you any specific performance issue, then post it here so that some suggestions can be made.

Ramesh.

[Former Member]

Hi Lisa Roy,

Use SE30 to see the performance details.

For an Efficient program:

The load on Database should be low and the load on ABAP should be high.

[Former Member]

Do you have a specific problem?

Rob

[Former Member]

Here are some links that may help.

http://www.sapinsideronline.com/searchspi/search.htm?page=article&key=20297&query_text=performance%7...

http://www.sapinsideronline.com/searchspi/search.htm?page=article&key=44221&query_text=performance%7...

[Former Member]

Here are some points that are considered for performance tuning of a program.

1. Use select statement with complete key or use indecies.

2. Joins of different tables can be used if the join is properly defined in selects.(Again No. of tables that can be used in join also is a key factor )

3. select into table is adviced instead of corresponding fields

4. use where condition in a loop if the condition is known.

5. read an internal table with binary search (after sorting)

As one of our friend has suggested, it is a big topic and we need to act accordingly when the problem exists

[Former Member]

Hi Lisa,

There are several tools for performance tuning

1. runtime analysis (transaction SE30)

2. SQL Trace ST05

3. Dynpro Trace ST20

which gives you a detailed summary about where your application spent the most time.

Refer:

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/advancedsearch?querystring=performance%20tuning&searchpluginname=sdn">help On Performance Tuning</a>

[Former Member]

Hi Lisa

For imrpoving the performance use many Sy-subrc statments. Reduce the load on DB. Using "into Corresponding fields" will increase the load on DB.Rather go for some hardcoding and Use Select n Endselect.

A good program will above 50% load and ll be displayed in red color for ABAP, less than 25% laod for DB and system in SE30 perfomance tuning.

[abdul_hakim]

Hi,

Do Runtime Analysis(SE30) to check how much time your program is taking at the application server and database server level.It is should be equal to 50% or less.If it is more than this then you need to improve the performance of your program.If your program is taking much time at the database level then you do the SQL Trace (ST05) to check which SQL query is taking much time..

If your program is taking more time at the applcation server level then Try to remove the nested loops with READ TABLE statements.Hope this will help you..

Regards,

Abdul

[Former Member]

Lisa,

Is your problem solved.

If solved then close this discussion and award points to all useful answers.

Thanks,

Ramesh.

[Former Member]

Hi all,

As every one said to use se30 but after runnning se30 i have given name of the program and i executed there after what i have to do.

Surely i will reward the points for helpful answers and i will close the post

Message was edited by: Lisa Roy

[amit_khare]

Hi,

In SE30 first execute your program. then come back and check with ANALYZE button.

it will give you the different access time of the program.

Also you can put extended checks with ST05 and check the SQL of the program.

Amit

[Former Member]

Just execute the Program if you want to see the Performance using <b>analyze</b> button

after running see the ABAP runtime,DATAbase Runtime,

system runtime..

[Former Member]

you can see how much load on System,Database,ABAP...

Some Graphical representation will be there..

regards

vijay

[Former Member]

after giving the program name run it

and click back until it doesn't take u the the se30 screen, once you are in se30 screen click on analyse then it ll display all the details.

[Former Member]

Hi,

To increase the performance, try following things,

1. Avoid using nested loops.

2. Avoid using nested selects.

3. Avoid using select...endselect. instead use select on internal table.

4. Avoid using select * ... instead use the fields.

5. Avoid select under loops, instead use 'for all entries'

For more help access sap help on performace optimization.

Regards,

Hemant.

[Former Member]

Hi,

In addition to the above points, retrieve the data from tables which have bulk amount of data using Shared Object Memory(SOM). This will drastically improves performance.

Regards,

Vamsee