WHAT IS PEFORMANCE TUNING?
Answers were Sorted based on User's Feedback
Answer / amith
Performance tuning is a technique used to fine tune your
ABAP programs when they have complex select statements and
huge set of data to be accessed from database.
Performacne of a scelect statement or a program can be
tested using tools like SE 30- Runtime analysis and SQL
Trace ST05.
Other than this there are set of thumb rules that can be
followed:
1) Keep the data selection small.
 Avoid unnecessary data across the network
 Always use the where clause
 Avoid selecting useless data we filter later.
 Use the index of the relevant database tables to
make the where clause more efficient
 Avoid using complex where clauses
 If possible avoid using the NOT in conjunction with
the where clause.
2) Transport as little data as possible
• transport only fields that are really used
• use the aggregate functions in the select clause
for calculations
• Consider using the distinct statement if there is
possibility of duplicate entries
3) Use fewer data base access
• Transfer all of the data at once frm data base to
internal tables.
• When possible avoid accessing the same data again
and again
• Avoid using nested loops instead of that use an
internal table and use the select for all entires statement.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / hariabap
we can analyze performance of any program by using t.code
se30( runtime analysis). there we can see performance of
database server , application server and processor . If
database is taken more time , try to modify select staments.
Hence performance of program can be improved.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mohamed
Performance tuning is something related to incresing the
performance of the program ie not giving the full load to
the application server.
this can be done in following methods,
1. using corresponding buffering.
2. not using SELECT *
3. maximum usage of WHERE condition
4. using VIEWs
5. mentioning exactly 'occurs n'
and so on
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / abapchaitanya
performance tuning is used to see the status of object
means make that object portable and effcience, and replace
with new suitable statements, method for the performance
tuning is sql tracer,....
Is This Answer Correct ? | 4 Yes | 4 No |
What do you do when the system crashes in the middle of batch session?
What is IMG in SAP?
what is the difference b/w linear search and binary search? (how can these search)
15 Answers HCL, IBM,
what are nodes in smart forms?
what the tcode to check the consistency of work flow for ALE /EDI in a inbound error processing?
What is the diffrence between Abstract Class and an Interface in OOABAP.
What is the difference between User Exits and BADI?
5 Answers Accenture, IBM, SAP Labs,
How can we handle table control in bdc? : abap bdc
how to use table control in bdc
How you will catch errors in call transaction?
What does the extract statement do in extract datasets? : abap modularization
What are the different types of views in sap? : abap data dictionary