topic Enhancing performance for loop inside loop processing.......... in Application Development and Automation Discussions

Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:24:26 GMT

Hi ,

my current program has the following code

Loop at itab1.

..................

loop at itab2

where f1 = itab1-f1.

endloop.

..............

endloop.

in itab1 there 20,000. and itab2 there are 10,000 records

The above code is causing a great bottle neck .is their any way to enhance the performance.

please help .

Re: Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:27:27 GMT

Use the Parallel Cursor technique.

data: v_tabix type sy-tabix.
Loop at itab1.

..................
Read table itab2 into wa_tab2 with key .........
if sy-subrc eq 0.
v_tabix = sy-tabix.
loop at itab2 into wa_tab2 from v_tabix.
if wa_tab2 ne field1.
exit.
endif.

endloop.
endif.

..............

endloop.

Regards

Kannaiah

Re: Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:27:53 GMT

Hi,

~ if you have any duplicates in itab1, just process the loop for 1st pass.

~ you can use [parallel cursor method|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/abap%2bcode%2bfor%2bparallel%2bcursor%2b-%2bloop%2bprocessing]

regards,

madhu

Re: Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:29:44 GMT

From the ABAP editor go to the menu path Environment->Examples->Performance Examples and look at the Parallel Cursor technique under internal tables->simple algorithms->nested loops.

Gareth.

Re: Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:34:39 GMT

Write the nested loop logic as shown below. This will reduce the execution time to maximum.

SORT itab1 BY f1.

SORT itab2 BY f1.

LOOP AT itab1.

LOOP AT itab2 FROM w_index.

IF itab1-f1 NE itab2-f1.

w_index = sy-tabix.

EXIT.

ENDIF.

ENDLOOP.

****Reward points if useful

Regards,

Kiran Bobbala

Re: Enhancing performance for loop inside loop processing..........

Former Member — Mon, 09 Jun 2008 13:55:27 GMT

Thnkx Madhu