nested loop

[Former Member]

Hi Experts,

This is an performance issue.I received a ticket to resolve it.but the code is using nested loop in each loop it is using the database from one table.how to resolve it .

thanks

[Former Member]

hi,

you can use the statement for all entries for selection of data later you can read that table with specific key so that you can reduce the triggering of the data base more times.

hope it will help u.

[amit_khare]

Hi,

1. Use Inner Joins

2. INTO TABLE

3. No nested loop

4. FOR ALL ENTRIES

5. Use as much of the key as possible

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5d0db4c9-0e01-0010-b68f-9b1...

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

Regards,

Amit

Reward all helpful replies.

[former_member194669]

Hi,

You can make initial select using " for all entries" then within the loop, if you seach for only one record then use "read" other wise loop inside loop.

if you want mre specific reply please paste the code

aRs