topic Re: Report Performance - timeout short dump in Application Development and Automation Discussions

Report Performance - timeout short dump

rnb86 — Thu, 19 Feb 2009 11:17:19 GMT

Hello Experts,

i am trying to improve the performace of a report that was developed long time ago.

Issues i found:

1. The report has many select...Endselect combinations, and selects inside the loop statements.

2. Most of the selects have the addition 'into corresponding fields of' for selecting a few fields, without the table addition.

3. Also few selects have the 'select * from' syntax.

data: begin of itab occurs 0,

f1,

f3.....

fn,

end of itab.

Ex: loop at itab.

select f1 f2 f3 from table1

into corresponding fields of itab1.

collect itab1.

endselect.

select f4 f5 from table2

into corresponding fields of itab2.

endselect.

endloop.

All this leeds to performace issues.

i have checked ST05, and i have got the details of the error.

My question is which one of the reasons i mentioned above are a major factor in delaying the report performance?

Which one of the above should i conetrate first to get the long runtime down? My goal is to keep my changes to the minimum and improve the performance. Please advise.

Re: Report Performance - timeout short dump

Former Member — Thu, 19 Feb 2009 11:46:39 GMT

Hi,

check below link

ABAP Performance and Tuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning

Regards,

Madhu

Re: Report Performance - timeout short dump

h_senden2 — Thu, 19 Feb 2009 12:00:35 GMT

1. Within the loop on itab, i dont a selection on the itab-record in the 2 select statements.

2. Select ... Collect .... Endselect : is it not possible to use another select statement with SUM( ), GROUP BY and HAVING. So you totalize the data per group.

regards,

Hans

Re: Report Performance - timeout short dump

Former Member — Thu, 19 Feb 2009 13:04:49 GMT

> My question is which one of the reasons i mentioned above are a major factor in delaying the report

> performance?

Don't ask people for guesses, if you can see the facts!

Run the SQL Trace several times, and use go to 'Trace List' -> 'Summarize Trace by SQL Statement'

=> Shows you total DB time and time per statement (all executions), the problems are on top of the list.

Check ABAP, detail, and explain!

Re: Report Performance - timeout short dump

Former Member — Wed, 04 Mar 2009 21:46:09 GMT

Hi,

You can do runtime analysis through transaction ST12 and the SCII (Code Inspector) transaction to verify the syntax of the code source, which generates a detailed report with the evaluation of the code and suggestions of improvements.

hope this information is help to you.

Regards,

José

Re: Report Performance - timeout short dump

rnb86 — Wed, 28 Oct 2009 13:23:13 GMT

done.