SAP ABAP程序性能优化

Performance Tuning

Contributed by Henrik Frank For all entries Nested selects Select using JOINS Use the selection criteria Use the aggregated functions Select with view Select with index support Select … Into table Select with selection list Key access to multiple lines Copying internal tables Modifying a set of lines Deleting a sequence of lines Linear search vs. binary Comparison of internal tables Modify selected components Appending two internal tables Deleting a set of lines Tools available in SAP to pin-point a performance problem Optimizing the load of the database For all entries The for all entries creates a where clause, where all the entries in the driver table are combined with OR. If the number of entries in the driver table is larger than rsdb/max_blocking_factor, several similar SQL statements are executed to limit the length of the WHERE clause. The plus Large amount of data Mixing processing and reading of data Fast internal reprocessing of data Fast The Minus Difficult to program/understand Memory could be critical (use FREE or PACKAGE size) Some steps that might make FOR ALL ENTRIES more efficient: