ITPub博客

首页 > 应用开发 > IT综合 > 一个CRM OData的性能问题分析

一个CRM OData的性能问题分析

原创 IT综合 作者:i042416 时间:2020-02-16 08:35:57 0 删除 编辑

In My appointment application, when jerry clicks F4 on account field, there will be odata request to retrieve account information.

To my surprise, this odata request took more than one minute to get response:

Then I did a performance trace in jerry system and found out most time is spent on your code CL_CRM_BP_ODATA_RT~ SELECT_ENTITYSET_BY_SQL.

I wrote a report in jerry system MOR/300 to reproduce this performance issue, report name: ZTEST_APP_PERFORMANCE. Simply execute it and you will find the issue.

In jerry system there are 645,212 entries in BUT000, and in AG3/001 I execute the same report ( report name: ZSEARCH_BP_IN_APPOINTMENT ) with BUT000 entries 60,452.

The performance of these two systems are quite different, even considering the table volume difference:

In jerry system: 645,212 entries, 81 seconds

In AG3/001: 60,452 entries, 0.178 second

Even if I disable the authorization related search field,

The performance is a little bit improved but still bad: 645,212 entries, 56 seconds

I am using MaxDB.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24475491/viewspace-2675747/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
SAP成都研究院开发专家,SAP社区导师,SAP中国技术大使。

注册时间:2018-01-20

  • 博文量
    1301
  • 访问量
    554700