03-10-2007 4:38 AM
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
03-10-2007 4:42 AM
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.
03-10-2007 4:44 AM
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
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
Regards,
Amit
Reward all helpful replies.
03-10-2007 4:45 AM
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