Optimizing Database Access
Efficient programming is first and foremost based on optimal database access. You can achieve this through effective use of the SELECT statement.
To display examples of how you can attain optimal performance, choose Test ® Runtime analysis from the ABAP Workbench (or Transaction SE30), then choose Tips & Tricks.
Using SQL Trace and the Runtime Analysis Function
To check the performance of your ABAP functions, use the performance trace or runtime analysis utilities. Choose System® Utilities ® Performance trace or System ® Utilities ® Runtime analysis. For further information about these tools, see ABAP Workbench Tools.
Using the Workload Statistics
To check your system performance, check the workload statistics (transaction ST03). You can display the workload statistics for the server on which you are currently working, for another server, or for all servers. The statistics provide detailed information about response times and resource use.
You can carry out the workload analysis for any of the following:
If you encounter an acute problem, start by analyzing the current day.
The transaction profile gives the average behavior of a transaction. You should pay particular attention to the transactions which take up most database time. You can usually reduce the system load and improve performance considerably by analyzing the three to five transactions taking up the most database time.
For help interpreting the performance monitor, choose Help