topic Re: reducing execution time? in Application Development and Automation Discussions

reducing execution time?

Former Member — Wed, 06 Jun 2007 06:21:59 GMT

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.

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:24:17 GMT

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.

Re: reducing execution time?

amit_khare — Wed, 06 Jun 2007 06:25:45 GMT

Check the thread -

Regards,

Amit

Reward all helpful replies.

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:26:17 GMT

HI,

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

Regards,

Naveen

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:26:55 GMT

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.

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:27:31 GMT

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

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:27:51 GMT

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

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:28:01 GMT

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

Re: reducing execution time?

Former Member — Wed, 06 Jun 2007 06:29:11 GMT

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^