Performance issues

[Former Member]

Hi all,

I got requirement to increase te performance to one program which is written in 2006 by my old team mates.

I checked in sm30..the load is very high and it is taking long time to execute as result ending in time out..

can soem one plz help me how to proceed on this....

Any tips ..?

It wolud be a very great help..

Thanks i

[Former Member]

1. Avoid select*

2. Avoid select statement within loop.

3.Use field symbols instead of structures (e.g. loop at itab assigning <FS_name>)

4. If the program is updating some database table for multiple records then check it should be updated by internal table, not by single single record.

[Former Member]

Hi Thanks gor u r reply,

Can you plz provide example for 4th point..it would be very help ful..

Thanks..

[Former Member]

Hello,

Have you run a SQL trace (ST05) or an ABAP runtime trace (SE30) on this program? If you could do that and then post the most expensive ABAP statements here, we would be able to help you much more efficiently. Even if you don't master those tools, simply monitoring the running program with SM50 might already give you an indication.

There is a lot of "good practice" advice (see for example previous reply to your post) but some of the top performance killers in ABAP code are:

1) Expensive SELECT because WHERE clause cannot use a proper index

2) Expensive SELECT because of condition "WHERE field IN sel-options" and user has left sel-options list empty on the selection screen (result = select everything)

3) Expensive read access on a large internal table because of sequential read (missing BINARY SEARCH, or standard table used where sorted/hashed table would be needed)

If a program times out, then those are the performance killers I would look out for first.

Regards,

Mark

[Former Member]

Please do not ask or answer questions like this. The OP should read the stickies at the top of the forum before posting.

Thread locked.

Rob