Optimizing Performance

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. In the SQL interface group box, you will find examples of how to use the SELECT statement.

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:

  • the current day
  • a previous day
  • a previous period (day, week, month)
  • an application server
  • all application servers

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 ® Application help from the relevant transaction.