天天看点

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:

SAP CRM Fiori 应用 my Opportunities 的后台性能分析
SAP CRM Fiori 应用 my Opportunities 的后台性能分析