Optimize program abap

Note however that for very large result sets it might not be a feasible solution and you would want to let the datbase server sort it. This can be a potential bottle neck. Memory consumption of the database resources eg. CPU consumption on the database and application servers. Network communication — not critical for little data volumes, becomes a bottle neck when large volumes are transferred.

Policies and procedures can also be put into place so that every SAP-customer development object is thoroughly reviewed quality — program correctness as well as code-efficiency prior to promoting the object to the SAP-production system. Spend time documenting and adopt good change control practices. Spend adequate time anayzing business requirements, process flows, data-structures and data-model. Quality assurance is key: plan and execute a good test plan and testing methodology.

Always specify your conditions in the Where-clause instead of checking them yourself with check-statements. The database system can also potentially make use a database index if possible for greater efficiency resulting in less load on the database server and considerably less load on the network traffic as well.

If you want to find the maximum, minimum, sum and average value or the count of a database column, use a select list with aggregate functions instead of computing the aggregates within the program. The last trace that was run is suggested as the default value. ABAP Development. Browse pages. A t tachments 0 Page History. Jira links. Created by Former Member , last modified on Dec 14, If initial data selection itself is huge. User then would know, which can improve response and which cannot. If the report is used for on-line purpose only, drill down report would be better alternative.

Get more information only when you need it! Tcode SAT:. SAT transaction is the replacement of the pretty outdated SE Provides same functionality as SE30 plus some additional features.

Step1: Go to tcode SAT. The screen is similar to SE30 screen. One new tab Evaluate has been added to the screen. Variants — The Basis of All Measurements.

Instead of using logic to do summation use collect statement. For example: if there is a loop like this. Condition added, otherwise there is no optimization:. Instead we can use If possible use joins instead! GURU, select You will find the same issue for many many statements and technologies, like logical database for example.

Does this improve performance? Will this work for performance? ABAP Development. Browse pages. A t tachments 0 Page History. Jira links. What tools can be used to help with performance tuning? Does SAP publish guides and cookbooks on performance monitoring and testing? Avoid use of nested loops What tools can be used to help with performance tuning?

SE30 is the Runtime Analysis transaction and can be used to measure the application performance. Very important!!