Skip to Content
avatar image
Former Member

Analysing details of SQL trace and runtime analysis for a report.

Hi,

I am trying to tune the performance of a Z ABAP report for target group export. A brief overview of what is done in the report is the retrieval of BP details present in the Target group including BP general, address, marketing attributes, person responsible and contact person details. As the target groups can be quite huge (around 6000 BPs), the report gives performance issues. I want to understand on how to analyse the details which I obtained from the run time analysis and SQL trace and on how to take it forward.

Any inputs in this regard would be helpful.

Thanks in advance,

Anushree

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 04, 2008 at 07:01 AM

    In Runtime analysis Look for

    ABAP - In your ABAP code

    DATABASE - It shows the performance of your SELECT statements in your program.

    Just check how much % it is showing for both.

    Check for following in your code.

    1) Avoid SELECT *

    2) Clear internal tables values which are not required at the ending of program, as it saves memory

    etc.

    Add comment
    10|10000 characters needed characters exceeded