topic Re: Performance issue in Application Development and Automation Discussions

Performance issue

abdulazeez12 — Fri, 11 Aug 2006 09:33:23 GMT

Hii all,

I have two internal tables itab1 and itab2, both having huge data. I want to compare if itab1 and itab2 have same records in them. If so, I need to delete records from itab1. So, I put like this in code:

loop at itab1.

loop at itab2.

if < conditions>

delete itab1.

endif.

endloop.

But this is giving me serious performance issues. Can anyone help in this regard. Whats the best statement that can be used to increase the performance?

Urgent help needed.

Thanx in advance.

shakir

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:36:55 GMT

sort itab1 by field1 field2.

sort itab2 by field1 field2.

loop at itab1.

lv_index = sy-tabix.

read table itab2 with key field1 = itab1-field1

field2 = itab1-field2 binary search.

if sy-subrc = 0.

delete itab1 index lv_index.

endif.

endloop.

Regards,

Ravi

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:37:24 GMT

Hi shakir,

1. suppose u want to delete from itab1.

2. then (using matching key)

3. LOOP AT ITAB2.

<b> READ TABLE ITAB1 WITH KEY FIELD1 = ITAB2-FIELD1

FIELD2 = ITAB2-FIELD2.

IF SY-SUBRC = 0.

DELETE ITAB1.

ENDIF.</b>

ENDLOOP.

regards,

amit m.

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:37:43 GMT

HI,

sort itab2 by <fieldname>

Loop at itab1.

read table itab2 with

key <fieldname = itab1-fieldname>

binary search.

if sy-subrc = 0.

delete itab1.

endif.

endloop.

regards

Subbu

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:39:16 GMT

sort itab2 by <field>.

loop at itab1

read table itab2 with key <cond>

binary search.

if sy-subrc = 0.

delete itab1.

endif.

endloop.

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:40:32 GMT

Hi,

Add one more column called 'MARK' in itab1.

1. Don't delete a table entry while looping it.

2. Don't use loop inside loop ( Not advisable )

Loop at itab1 <WA1>.

read table itab2 into <WA2> with key

aa = <WA1>-aa.

if sy-subrc EQ 0.

<WA1>-mark = 'X'.

modify itab1 from <WA1> transporting MARK.

endif.

endloop.

delete itab1 where MARK = 'X'.

Regs,

Venkat Ramanan N

Re: Performance issue

Former Member — Fri, 11 Aug 2006 09:49:54 GMT

Hi,

just try this.

loop at itab2.

read table itab1 index sy-index.

delete table itab1 with table key

fieldname = itab2-fieldname1 fname2 = itab2-fname2.

endloop.

i hope this works well, please reward if it is helpful

Regards,

Sowjanya