performance issue

[Former Member]

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?

[former_member585060]

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

[Former Member]

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?

[Former Member]

Hi,

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

Luck,

Bhumika

[Former Member]

hi,

the Text Means

Check that TA-date in the desired interval

Plz check the values in the date Field.

Regards

Sumit Agarwal

[Former Member]

Hi,

How to remove the GET statement?

[Former Member]

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á

[Former Member]

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

[former_member194613]

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

[Former Member]

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

[Former Member]

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.