topic Re: Long Calculation within loops in Application Development and Automation Discussions

Long Calculation within loops

Former Member — Mon, 12 Mar 2007 10:05:37 GMT

Hi,

I'm facing problems with a FI report. The batch job took approx 4hours for one variant and some variants can't even complete on time. For this case, out of the 4hrs, only 1 hour is due to SQL access.

I've traced the 3hr performance problem to a form which does calculation and sum of figures within loops.

What could be the problem... or what would be a good way to further investigate this?

So far I have only done performance tuning for programs due to inefficient SQL statements.

So, this is something new to me.

Thanks!

Re: Long Calculation within loops

Former Member — Mon, 12 Mar 2007 10:11:54 GMT

Hi Charles,

Check the link below which gives tips such as use of BinarySearch with Read table . Also in on of the reports i created , i found that all the dynamic stmt's are time consuming. Hence i tried to avoid them as much as i can. Paste the code in the form routine also to investigate the problem further.

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

Re: Long Calculation within loops

Former Member — Mon, 12 Mar 2007 10:19:41 GMT

read is not the problem. it doesnt use read.

some of the key abap used are:

within loop. ..

at new.

sum

compute

modify

what can cause several hours of processing?

any experts? i'll reward generously. thanks.

Re: Long Calculation within loops

Former Member — Mon, 12 Mar 2007 10:22:18 GMT

Hi Liu ,

which transaction u are running , tuning will be based on the transaction to transaction.

Regards

Prabhu

Re: Long Calculation within loops

Former Member — Mon, 12 Mar 2007 10:26:44 GMT

This is a customised FI report.

Re: Long Calculation within loops

Former Member — Tue, 13 Mar 2007 07:41:13 GMT

found something interesting...

it's something to do with this code..

& i think is the get time field

FORM timestamp USING value(itext) TYPE c.

GET TIME FIELD ts-uzeit.

MOVE sy-datum TO ts-datum.

MOVE itext TO ts-event.

APPEND ts. CLEAR ts.

IF sy-batch EQ x

OR write_ts EQ x.

MESSAGE s020(nn) "&

WITH itext.

ENDIF.

ENDFORM.