Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Performance techniques?

Answer Posted / ramesh

(1) Try not to delete a record from internal table with in
a loop. Every time when you delete a record from internal
table the index of the table is regenerated and this can be
a major performance issue. So if you have to delet a record
from internal table, create an additional column in the I.T
say del_ind and you want to delete the record for a
particular condition. then the code should go something
like this

loop at itab.

...
...
if <cond> .
itab-del_ind = 'x'.
modify itab transporting del_ind.
....
.......
endloop.

delete itab where del_ind = 'x' .


(2) Always sort the internal table by <key> and try to use
the statement Read table itab with key = <kwy> binary
search.

(3) Instead of joins use the for all entries option

(4) If the number of entries in the internal table are less
and you want to modify the internal table in loop, then its
better to go for field symbols than the regular
loop at itab.
.....
modify itab
,,,
endloop.

The overhead of reading the internal table record into itab
header can be avoided. Field symbol directly modifies the
record in the current loop pass

I will post more whenever i get free time again
Hope these are helpful

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference of update types in call transaction method ? : abap bdc

1165


Can we create field without data element? If yes, how?

1155


How to display if the value entered contains records or not?

1066


We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???

2108


How can one distinguish between different kinds of parameters? : abap modularization

1095


What is the difference between function group and function module?

1036


What are the dis-advantages of logical databases? : abap hr

1149


How do you write a function module in sap?

1079


What is an rfc?

1247


What is generic area buffering in abap?

1069


What is the use of 'for all entries'?

1064


Explain the function module in bdc?

1041


IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.

1936


How would you set the formatting options statically and dynamically within a report?

1093


To find the date difference & excude saturday & sunday in between them

2025