topic performance tuning in loop at itab statements in Application Development and Automation Discussions

performance tuning in loop at itab statements

Former Member — Mon, 29 Mar 2010 04:40:47 GMT

Hi ,

I have one internal table lets ITAB1[] ,

Its having 15,0000 Records.

now I want to search only 5 records from ITAB1[] compairing ITAB2[] , ITAB2 having 15,0000 records.

what is best method to search this records in minimum time.

loop it ITAB1.

Read table ITAB2 with = ... binary search.

Endloop.

Prblem is that , above statemnt will take 15,0000 intration at each statment while reading.

Re: performance tuning in loop at itab statements

Former Member — Mon, 29 Mar 2010 04:52:54 GMT

Hi,

{SORT THE TABLE WITH PROPER CONDITON.

LOOP AT ITAB2INTO IS_ITAB2.

READ TABLE ITAB1 INTO IS_ITAB1 WITH KEY ..........

IF SY-SUBRC = 0.

W_TABIX = SY-TABIX.

LOOP AT IT_ITAB1 INTO IS_ITAB1 FROM W_TABIX.

IF ( PLEASE CHECK THE CONDITON MENTIONED FOR THE BINARY SEARCH HERE )

ELSE.

EXIT.

ENDIF.

ENDLOOP.

}

Please try this this parallel curosor method.. Performance is good..

Regards,

Srinivas.

Re: performance tuning in loop at itab statements

jayesh_gupta — Mon, 29 Mar 2010 04:53:21 GMT

Hi,

Could you please elaborate further how are you trying to compare the records between the two internal tables.

Regards,

Jayesh

Re: performance tuning in loop at itab statements

Former Member — Mon, 29 Mar 2010 05:27:04 GMT

Hi,

loop it ITAB1.
Read table ITAB2 with = ... binary search.
Endloop.

I think whatever code you are using now is appropriate only.

As you want to read record from ITAB1 based on data in ITAB2, you will have to loop at ITAB2 and then do binary search on ITAB1. Just make sure that your table ITAB1 is sorted correctly as per the binary search criteria.

Thanks,

Archana

Re: performance tuning in loop at itab statements

SuhaSaha — Mon, 29 Mar 2010 05:30:28 GMT

now I want to search only 5 records from ITAB1

Based on what conditions you have short listed the 5 records of ITAB1 ? Are the fields involved defined (or can be defined) as key fields of the internal table?

BR,

Suhas