SAP_ABAP_性能优化.pptVIP

ABAP性能优化 SAP Labs China Shanghai, July 2010 使用Field Symbols 嵌套表的处理 使用Index索引 Improving performance Reduce number of lines used Reduce search area Implement mass processing Reduce copy costs in a work area or header line ARRAY FETCH Inserting Internal Tables Limited Mass Data Accesses Selective Field Transport Using Field Symbols Access on Tables without Field Transfer Reading Single Records Hashed Table Sorted Table Standard Table Composing Unique Internal Tables Processing Nested Tables Mass Processing Using an Index Interval R/3 SYSTEM ANALYSIS R/3 systems analysis: Identifies performance critical objects Collates information for further analysis of objects Should be performed only on the production system To be performed by developers, system or database administrators,performance tuners Prerequisites: Absence of basic problems (R/3 basis, database, hardware) Functioning R/3 and database monitors Representative user activity Different Tools for Optimization and Their Usage To Determine Appropriate Index is used or not. Code Inspector (SCI). SQL Trace (ST05). Complete WHERE Clause Code Inspector (SCI). SQL Trace (ST05). SAP Buffer Code Inspector (SCI). SQL Buffer Trace (ST05). Global performance Analysis (ST30) No identical Selects SQL Trace (St05). Global performance Analysis (ST30) Parallel Processing SQL Enque/RFC Trace (St05). Linear Dependency Code Inspector (SCI). Runtime Analysis (SE 30) Two Communication Step per Dialog step SQL Trace (St05). Global performance Analysis (ST30) Load Analyzer (ST03N) Average Dialog time below 2 seconds Global performance Analysis (ST30) Load Analyzer (ST03N) Questions And Answers 在select语句后面的where附加项中可以使用左关联，这会极大的提高程序速度，但同时也有一些局限，如下：重复项会被从结果数据集中自动删除，因此要注意在select语句中需要给出详细的唯一关键字组合。so, 尽量不要使用JOIN进行多表连接。把一个表的数据先取到内表，然后使用FOR ALL ENTRIES语句再进行抽取。 如果 For All Entries IN 字段修饰的内表是空表的话，源表的所有行都会被选入目标表中。因此在使用前一定要首先检查第一个表是否为空，这一点很重要，否则会有performance问题。 如果 For All Entries IN 字段修饰的内表很大的话，程序速度反而会减慢，而不是加快。因