SAP ABAP程序性能优化

本文探讨了如何优化SAP ABAP程序的性能,包括高效使用数据库表格、减少数据库处理时间以及最佳编程实践。通过对代码进行调整和利用ABAP特性,可以显著提升系统运行效率。
摘要由CSDN通过智能技术生成


                                                              Performance Tuning

Contributed by Henrik Frank

  1. For all entries

  2. Nested selects

  3. Select using JOINS

  4. Use the selection criteria

  5. Use the aggregated functions

  6. Select with view

  7. Select with index support

  8. Select … Into table

  9. Select with selection list

  10. Key access to multiple lines

  11. Copying internal tables

  12. Modifying a set of lines

  13. Deleting a sequence of lines

  14. Linear search vs. binary

  15. Comparison of internal tables

  16. Modify selected components

  17. Appending two internal tables

  18. Deleting a set of lines

  19. Tools available in SAP to pin-point a performance problem

  20. 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:

    评论 4
    添加红包

    请填写红包祝福语或标题

    红包个数最小为10个

    红包金额最低5元

    当前余额3.43前往充值 >
    需支付:10.00
    成就一亿技术人!
    领取后你会自动成为博主和红包主的粉丝 规则
    hope_wisdom
    发出的红包
    实付
    使用余额支付
    点击重新获取
    扫码支付
    钱包余额 0

    抵扣说明:

    1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
    2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

    余额充值