Tips for ABAP Performance Tunning
来源:互联网 发布:淘宝客高佣金计划 编辑:程序博客网 时间:2024/05/22 01:36
1. The average database time for a sequential read (SELECT … ENDSELECT, SELECT … INTO TABLE) should be around 10 milliseconds per data record, while for a direct read (SELECT SINGLE …) it should be around 5 milliseconds per data record.
2. Accesses that change data (UPDATE, INSERT, MODIFY, DELETE) should require around 20 milliseconds per data record. The times stated are for actually reading data from disk in the database.
3. If the data records are read from the database buffer, around 1 millisecond is required instead of approximately 10 milliseconds per data record. If the required data are located in the R/3 buffers on the application server, accessing them requires approximately 0.1 milliseconds (100 microseconds) per data record.
4. As a general rule you should consider any SQL access that exceeds 200,000 ms to be a problem. This includes a single database operation or a nested SQL statement with the same strategy (total of all SQL statements nested together). Likewise a SQL statement with 10 or more FETCHes should generally be considered a problem.
5. Base on the result of Workload Monitor (ST03), if the database time is greater than 40% you should start with the SQL Performance Trace. If the CPU time is greater than 40% you should start with the ABAP Runtime Analysis.
6. In ST03 result, if the average database response time per transaction step is greater than 600ms, the cause is very probably a fundamental R/3 or database problem.
7. On some databases (for example, Oracle and Informix), fragmented indexes may occur. The term fragmented indexes means that index blocks are less than 50% full. Fragmented indexes can occur, for example, if a large number of table records are deleted and then a large number of table records are inserted. If you discover that an index is suitable for a SQL statement, but that executing the SQL statement causes heavy database system load, your database administrator should check whether a fragmented index is causing the problem.
continue...
- Tips for ABAP Performance Tunning
- Performance Tunning for Tile-Based Architecture
- Performance tunning pass
- jvm performance tunning
- Remote query performance tunning
- tile base performance tunning
- GPU performance tunning
- Performance tips for Cocos2d for iPhone
- Performance tuning tips for database developers
- 10 Tips for Flex Application Performance
- Some performance tips for Ext-Gwt
- 7 Tips for Improving MapReduce Performance
- Linux performance tuning tips for MySQL
- Performance Tips for Android’s ListView
- Tips for optimizing mobile graphic performance
- (转)Performance Tunning for Tile-Based Architecture Tile-Based架构下的性能调校
- Performance Tunning for Tile-Based Architecture(Tile-Based架构下的性能调校)
- Performance Tunning for Tile-Based Architecture Tile-Based架构下的性能调校
- MySQL汉字查询、外部jar包版本问题、模拟器版本同开发版本等问题
- Js:new Fun_name() & Fun_name()的区别
- Hash join算法原理
- 《Qt编程的艺术》——8.1.1 显示类(The View Classes)
- ASP.NET获取URL及虚拟根目录
- Tips for ABAP Performance Tunning
- 程序员笔试知识点整理
- Android 用application保存全局变量,关于Android中传递数据的一些讨论
- baiduMap 使用Fragment的方法
- Memcached Client Forjava API (http://blog.sina.com.cn/s/blog_7fe75a5901019o8g.html)
- HEVC学习(六) —— 帧内预测系列之四
- ABAP serch关键字
- Glade两种布局文件格式GtkBuilder和Libglade在python中的导入代码
- IE10内存防护机制 让黑手无机可乘【绿色】