topic Re: performance issue in Application Development and Automation Discussions

performance issue

Former Member — Wed, 30 Jul 2008 08:40:40 GMT

Hi,

I need to work on a program which is causing performance issue.But i don't know where in the program it is causing performance issue.How to find out this?

Re: performance issue

former_member585060 — Wed, 30 Jul 2008 08:49:58 GMT

Hi,

Goto SE30 and check for ur program, look at all ur select statements. for tips on select statements click on Tips & Tricks in SE30 and do an EPC check for ur program.

Regards

Krishna

Re: performance issue

Former Member — Wed, 30 Jul 2008 08:50:45 GMT

Hi!

You can use SE30 transaction for runtime analysis.

And of course you can place break-points all over in the program, and check between 2 break-points the elapsed time.

Regards

Tamá

Re: performance issue

Former Member — Wed, 30 Jul 2008 08:55:04 GMT

Hi,

run your program and check

1. in SELECT query avoid INNER-JOIN< .. CORRESPONDIG FIELDSOF..

2. Perform EP Check.

3. Check with code inspector.

Regards,

Anirban

Re: performance issue

Former Member — Wed, 30 Jul 2008 09:10:29 GMT

Hi,

I have done the EPC check to the program.It is not showing any errors but a few warnings.In the program at one point they have used the logical database statement

GET ltak.

*........Prüfen, ob TA-Datum im gewünschten Intervall...................

CHECK bdatu.

MOVE-CORRESPONDING ltak TO t_to_list.

How to remove this?

Re: performance issue

Former Member — Wed, 30 Jul 2008 09:17:17 GMT

Hi,

Check the interval that you have given for the date field & try to avoid move-corresponding.Instead use MOVE.

Luck,

Bhumika

Re: performance issue

Former Member — Wed, 30 Jul 2008 09:18:12 GMT

hi,

the Text Means

Check that TA-date in the desired interval

Plz check the values in the date Field.

Regards

Sumit Agarwal

Re: performance issue

Former Member — Wed, 30 Jul 2008 09:20:09 GMT

Hi,

How to remove the GET statement?

Re: performance issue

Former Member — Wed, 30 Jul 2008 09:30:25 GMT

I need to work on a program which is causing performance issue.But i don't know where in the program it is causing performance issue.How to find out this?

Forget your random approach and the logical database, if you encounter a problem with an existing program then you MUST use the tools to figure out what causes the problem. All other recommendations are not worth to consider!

Do SE30 and SQL Trace:

SQL trace:

SE30

What is the total time, what is the ABAP Time what is the DB Time. Are there large contributions causing the problem?

Siegfried

Re: performance issue

Former Member — Wed, 30 Jul 2008 10:45:22 GMT

Hi,

Check theese things in your program,

The data traffic between the database server and the application server minimized by limiting fields selected by a proper WHERE clause and only to the fields actually needed?

Are SELECTu2026.ENDSELECT statements avoided by using INTO TABLE option?

Are nested SELECT statements avoided by using joins instead?

Are multiple SELECT SINGLE statements on the same database table avoided by using FOR ALL ENTRIES option?

If new entries must be added to internal table, are table rows added collectively via APPEND LINES instead of record-by-record?

If the table contents need to be changed, are table rows changed collectively by using INSERT/MODIFY/UPDATE FROM TABLE for custom database tables and MODIFY WHERE fro internal table instead of doing it record-by-record?

Has SQL trace been used in order to verify index use?

Hope this is helpful,

Thanks,

Vijay Duvvada

Re: performance issue

Former Member — Wed, 30 Jul 2008 13:33:14 GMT

Check the performance using SE30 if the ABAP is taking more resourse that you need to check your code. If the database is taking time may be you are using a cluster or a pool table in that case you need to get the data from some other logic. Also while coding try not to use nested select statements. Also avoid using Select * or into corrosponding fields.

Regards,

Prashant.