regarding performance issue

[Former Member]

hi experts

suppose one program performance will take 12 hour,regarding performance tunning technique used i minimised 12 hr to 8 hr.

the main question is again what r the methods/performance that we have to use

that decreases 8 hr to 2 hr.i faced recently this question from ibm.

thanks

subhasis

[Former Member]

1) Dont fire select query on same DB more than one time.

2) Check if itab is not initial when using FOR ALL ENTRIES.

3) Avoid two if condition for the radiobuttons having common radiobutton group like LIST & FORM in this case.

4) before creating field ALV stuff check output itab is not inital.

1. Before selecting sort the internal tables by the key fields.

2. Might be the internal table data is more use BINARY SEARCH when reading a table with key.

3. Use workareas instead getting data into internal table header.

4. For MODIFY statement give the row no. to modify with the values.

e.g: INDEX row_no TRANSPORTING FROM wa.

5. Clear fields, workareas whenever there is no use. FREE the tables which u don't require for further processing.

6. Give as many conditions while selecting data from database tables in WHERE conditions.

7. Don't use System variables directly like SY-INDEX while modifying or any process instead assign this value to ur local variable and use it.

8. Before selecting data from database tables using FOR ALL ENTRIES OF TABLE itab check whether the internal table u r using contains any data.

9. Instead of MOVE-CORRESPONDING assign the values directly to the fields of internal table and append

rewards points if help full

Regards

suresh.d

[Former Member]

hI,

Refer 'Tips and Trics' section of se30 tcode. i.e. performance tuning here you will get all important tips and trics.. that is more than suffient.

But, few tips are here:

ABAP performance is devided in three types 1. Database 2. ABAP 3. System

Generally system performance is constant and handled by applicaiton so ignore it.

Most important is u must imporve database performance which load can be shared by ABAP.

DAtabase :

1. Donot use into corrosponding fields clause

2. use only KEY fields in where condition

3. donot use select * inseead use select f1 f2.

4. use for all enries wherever necessary

ABAP

1. to read another itab inside a loop do not use another loop instead use read table stmt with with BINARY SEARCH.

2. Try to use field symbol this will improeve performance .

jogdand M B