reducing execution time?

[Former Member]

hi all,

Am running a report. It is taking long time for execution. What steps should i do to reduce the execution time.

thanks in advance,

ashu.

[Former Member]

hi,

It is taking so much time for execution in the sense u r hitting the entire db table.It's better to take specific fields instead of selectiong all the fields.

Goto se30 runtime analysis and check for which task its taking much time and better solve it.

[amit_khare]

Check the thread -

Regards,

Amit

Reward all helpful replies.

[Former Member]

HI,

goto extended syntax check, and see for which statement its taking more time, and remove unnecessary statements if any

Regards,

Naveen

[Former Member]

Replace inner joins with for all entries,

Use select single where you know all the primary keys else use upto one row

replace

loop.

Select.

endloop.

with

for all entries

Use binary search in internal tables

Use se30 runtime analysis and see the log and look at what were the tables consuming more time and try to use more keys in select statements.

[Former Member]

Hi,

use primary / secondary index keys in the where clause of the select query

DO NOT use a negative in the where clause - it negates the index.

While reading internal tables use binary search.

sort itab by <field1 field2>

read table itab with key <field1 field2> binary search.

before using for all entries check if the internal table has something .. else all records form DB will get selected.

Regards,

Guarav

[Former Member]

Hi,

Look at the Below Links, this will explain about the Tuning

http://www.erpgenie.com/abap/performance.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

Regards

Sudheer

[Former Member]

Hi Ashu,

T Code: ST05.

Run this transaction by giving your program name and executing your program and it'll analyse which select statement is consuming more time than usual. Use field symbols if possible.

Reward Points.

Thanks,

Tej..

[Former Member]

hi

good

go through this link which ll give you detail idea about the performance analysis of a report

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

thanks

mrutyun^