topic ABAP performance issue in Application Development and Automation Discussions

ABAP performance issue

Former Member — Wed, 06 Jun 2007 21:51:56 GMT

Hi,

I m facing a serious performance issue in ABAP report, it runs on massive data.

When i check it in se30, it takes 97 % of the time in Database processing. So I have to optimize it. It's a big report. Can anybody tell me, how can i find in SE30 or SE05 or in any other transaction, in which select or any other statement is taking more time, so I can optimize that statement.

Your help will be rewarded.

Thanks,

Khan

Re: ABAP performance issue

Former Member — Wed, 06 Jun 2007 21:56:56 GMT

Use ST05 Transaction.

goto ST05 Transaction -> click on Trace on -> enter ur transaction -> execute ur transaction-> once you see the results go back to ST05 transaction ->trace off->list display - > here you are able to see what sql query taking long time.

Re: ABAP performance issue

Former Member — Wed, 06 Jun 2007 21:57:11 GMT

Transaction ST05 is what I generally use.

Rob

Re: ABAP performance issue

Former Member — Wed, 06 Jun 2007 22:07:08 GMT

Transaction ST05 is highly recommended.

Steps:

1. ST05

2. Trace On

3. Execute the program and let it finish (make sure to vary parameters for each trace in order to get realistic values, since a cache is built and the second time is usually faster than the 1st.)

4. Trace Off

5. Display Trace (select radio button "detailed trace list")

Note the red colored areas, which reference to statements taking the most time (in seconds.)

Also, check over your program and do the following:

1. Make sure to use as many key fields as possible, when using both joins and where statements.

2. Instead of using '<>' in a where statement, create a range and fill it with the specific values, and do "where in <range>."

3. Speak to your team lead about the possibility of secondary indexes. This is very useful and has stripped much processing time from past projects. However, secondary indexes shouldn't be created for only 1 program, Make sure that the secondary index will also be used in the future (again, talk with you team lead.)

Visit the following URLS for more info on secondary indexes:

https://forums.sdn.sap.com/click.jspa?searchID=3023360&messageID=1633228

Also, in ST05, when displaying the trace, select the radio button "detailed trace list" for improved trace results.

Please reward if helpful.

Thanks,

John