REPORTs

[Former Member]

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.

[abdul_hakim]

hi

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..

[anversha_s]

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

[Former Member]

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

[Former Member]

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