topic Re: REPORTs in Application Development and Automation Discussions

REPORTs

Former Member — Fri, 15 Sep 2006 06:39:36 GMT

Hello Guys,

You are running a report. It is taking long time for

execution. What steps will you do to reduce the

execution time.

Please clarify...

Regards,

Ramesh M.

Re: REPORTs

abdul_hakim — Fri, 15 Sep 2006 06:42:37 GMT

you should use Runtime Analysis first for determining the runtime of your program using se30.

if your program is taking time at database operation then you can find the worst queries using

st05.

Cheers,

Abdul Hakim

Mark all useful answers..

Re: REPORTs

anversha_s — Fri, 15 Sep 2006 06:45:17 GMT

HI,

DO THis.

1. avoid select quesry inside loop.

2. in select quesry fetch only the needed fields from the DB

3.sort the internal table and use binary search.

4.inside whn u r chking some conditions, after satisfies the condition just exit.

5.use modify statment in place of INSERT AND UPDATE.

6.reduce the data base access.

7.do all the manipulations using internal table only.

8.reduce the declaration of variables in the pgm.

DEFINITLY, WHN WE CONSIDER THESE SMALL THINGS, IT WILL IMPROVE THE PERFORMANCCE OF THE PGM

RGDS,

ANVER

IF HLPED MARK POINTS

Re: REPORTs

Former Member — Fri, 15 Sep 2006 06:47:13 GMT

Hi,

for checking the performance run the SQL trace tool ST05 if you are using select statements you can know the time taken by each individual query.Also you can do a runtime analysis using SE30.

Regards,

Sangram

SAP Consultant

Re: REPORTs

Former Member — Fri, 15 Sep 2006 06:49:32 GMT

hi Ramesh,

1. Make sure that you are including all the key fields in your selct statement ..

2. It is not advisable to use select .. enselect statement .. use select .. into table itab..

3. sort the internal table before the read table statement ..

4. use binary search statement in read table statement.

regards,

Santosh