Skip to Content
0
Feb 19, 2009 at 11:17 AM

Report Performance - timeout short dump

40 Views

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,

f2

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.