topic Re: Nested Loop in Application Development and Automation Discussions

Nested Loop

Former Member — Sun, 27 Sep 2009 19:54:42 GMT

Hi ALL,

For every record in Outer loop i have to loop through internal table with date range to get total (from all the records that fall in date range) , i could do this but the problem is taking longtime 15min per data set, is there way we can improve . Though i have optimized the code to any extent but time remains same inspite clearing tables. Below are the SM50 Details if helps.

Roll In 0 0

Roll Out 0 0

Roll 229,376 (Bytes)

Page 24,576 (Bytes)

Memory (Total) 96,395,984 (Bytes)

Memory(Total Private) 0 (Bytes)

Memory (used) 88,013,664 (Bytes)

Memory (Max. Transaction) 96,395,984 (Bytes)

Memory (Max. Dialog Step) 96,395,984 (Bytes)

Regards

Kunal

Re: Nested Loop

Former Member — Sun, 27 Sep 2009 20:12:24 GMT

I feel it would be better if you could post your code, just in case if there is a room to improve the performance in the coding which you might not be aware of.

Re: Nested Loop

ThomasZloch — Mon, 28 Sep 2009 07:18:45 GMT

Check with SE30 where your code spends the time, make sure you use a TYPE SORTED TABLE for the inner loop, sort key according to the where-condition.

Thomas

Re: Nested Loop

Former Member — Tue, 29 Sep 2009 06:15:32 GMT

if both tables are as bellow reply you can use this logic

[|]

Thanks

nafran