11-24-2005 3:53 AM
How do you improve a program performance? What tools SAP has provided to monitor program performance?
11-24-2005 4:36 AM
Hi,
You can use the following transaction
SE30-Runtime Analysis
ST05-SQL TRACE
SCOV- COVERAGE ANALYZER
SLIN- EXTENDED PROGRAM CHECK
SCID-CODE INSPECTOR
This transactions will make your abap program a quality output.
If find useful please reward sutiable points.
Regards,
Irfan Hussain
11-24-2005 4:40 AM
A few tips you can use for finetuning a Report
1) Use mostly primary key to access data.
2) before READ u sort the itab
3) use mostly the indexes fields in ur where clause.
4) restrict the the fields retrieved by your select sentences to the minimal set. (avoid select *)
5) try to use specify where clause so the abap sql optimizer chooses the right index.
6) avoid sentences like select lifnr name1 into corresponding fields of lfa1 from lfa1 where ....
(you should declare a working area and select into the working area, is twice faster)
7) use hashed tables instead of standard tables. They are faster.
😎 Avoid the use of collect as much as you can.
******************************************************
1 Always check the driver internal tables is not empty , while using FOR ALL ENTRIES
2 Avoid for all entries in JOINS
3 Try to avoid joins and use FOR ALL ENTRIES.
4 Try to restrict the joins to 1 level only ie only for 2 tables
5 Avoid using Select *.
6 Avoid having multiple Selects from the same table in the same object.
7 Try to minimize the number of variables to save memory.
8 The sequence of fields in 'where clause' must be as per primary/secondary index ( if any)
9 Avoid creation of index as far as possible
10 Avoid operators like <>, > , < & like % in where clause conditions
11 Avoid select/select single statements in loops.
12 Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.
13 Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,)
14 Avoid using ORDER BY in selects
15 Avoid Nested Selects
16 Avoid Nested Loops of Internal Tables
17 Try to use FIELD SYMBOLS.
18 Try to avoid into Corresponding Fields of
19 Avoid using Select Distinct , Use DELETE ADJACENT.
*********************
If find helpful please reward sutiable points.
Regards,
Irfan Hussain