SAP CRM Fiori 应用 my Opportunities 的后台性能分析
The performance bottleneck of this url /sap/opu/odata/NBA/CRM_OPPORTUNITY_SRV/Opportunities()?KaTeX parse error: Expected 'EOF', got '&' at position 99: …ode eq 'E0003')&̲orderby=Score desc&KaTeX parse error: Expected 'EOF', got '&' at position 7: top=50&̲select=Id,CIFId,PriorityCode,SalesStageText,StartDate,ClosingDate,ProcessTypeText,OpportunityTypeText,EmployeeResponsibleName,ProspectShortName,OpportunityType,Description,Guid,UserStatusCode,ProcessType,Score,RelationshipView,Changed_At,Created_At
is in one order FM CRM_BSP_OIC_1O_SEARCH_FROM_RF itself. I have captured all the importing parameters for it and done an SAT trace in NR1/090, finally the bottleneck ( more than 3 seconds ) is found in the OPEN SQL below:
In the OPEN SQL there are inner joins on five large table:
CRMD_ORDER_INDEX INNER JOIN CRM_JEST AS CRM_JEST_H ON CRM_JEST_H~OBJNR = CRMD_ORDER_INDEX~HEADER INNER JOIN CRMD_ORDERADM_H ON CRMD_ORDERADM_H~GUID = CRMD_ORDER_INDEX~HEADER INNER JOIN CRMD_LINK ON CRMD_LINK~GUID_HI = CRMD_ORDER_INDEX~HEADER INNER JOIN CRMD_PARTNER ON CRMD_PARTNER~GUID = CRMD_LINK~GUID_SET
The table entries for each table are listed below:
CRMD_ORDER_INDEX: 25,694,983
CRM_JEST: 31,673,473
CRMD_ORDERADM_H:7,627,583
CRMD_LINK:45,508,977
CRMD_PARTNER: 27,277,824
Such inner join had poor performance and unfortunately, the OPEN SQL is populated dynamically via one order framework and could not be controlled by the application.
更多Jerry的原创文章,尽在:“汪子熙”:
相关文章
- SAP UI5 sap.ui.Device.media.initRangeSet 方法的单步调试
- Angular 里 HTTP 请求和响应结构的拦截器(interceptors)在 SAP Spartacus 中的应用
- 关于无法用 https 登录 SAP ABAP Netweaver 系统的问题和解决方案
- 关于 SAP Spartacus 重定向部分外部 url 到后台系统的问题
- 使用 SAP ABAP Memory Inspector 对应用程序消耗内存进行检测时常犯的错误试读版
- 关于 SAP Enterprise Portal 的前后端技术栈
- 如何自行查找出 SAP ABAP 标准的 OData 服务返回数据的后台数据库表和表字段名称试读版
- SAP中查找增强的可执行程序示例详解编程语言
- sap快捷搜索菜单栏详解编程语言
- SAP 预制发票时扣除已预制的数据详解编程语言
- SAP后台Job数据保存在表TBTCP/TBTCO中详解编程语言
- SAP中数据库表长度的界定详解编程语言
- SAP-EWM/ECC 系统后台配置详解编程语言
- SAP MM中如何修改物料的评估类详解编程语言
- sap的日期,时间详解编程语言
- SAP vs Oracle:差异点与解析(sap和oracle的区别)
- 比较:Oracle与SAP的对比(oracle和sap)
- Oracle与SAP在仓储领域的联姻(仓库oracle和sap)
- 数据库解决方案如何使用SAP创建Redis数据库(sap怎么创建redis)
- 对比Oracle和SAP价格比较哪个是更值得投入的选择(oracle与sap价格)