一个CRM OData的性能问题分析

  • 时间:
  • 浏览:1
  • 来源:大发彩神IOS下载_大发神彩IOS下载官方

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 200,452.

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.

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ANZPgsKn-15200818103722)(https://upload-images.jianshu.io/upload_images/2085791-389aca49200fcc13e.png?imageMogr2/auto-orient/strip)]

本文来自云栖社区合作伙伴“汪子熙”,了解相关信息都需要关注微信公众号"汪子熙"。

I am using MaxDB.

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:

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

In jerry system: 645,212 entries, 81 seconds

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

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

Even if I disable the authorization related search field,

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

猜你喜欢

1500左右 买哪个手机 性价比高点

本回答由明星微博 推荐你对你你你这个 回答的评价是?扫描二维码下载小米5不错,1599,性价比高很糙推荐ZUKZ2搭载高通骁龙82014nmKryo四核64位,最高2.15

2020-03-22

目前华为的哪款手机性价比最高

4、系统:搭载2.4GHz八核麒麟9500防止器,是顶级旗舰芯片,天生就越来越快,采用新一代EMUI5.1系统,成功实现了性能提升与功耗平衡的再次突破,带来难以想象的高速与流畅

2020-03-22

天猫天猫,今年双11哪些最值得买?

贝因美菁爱3段奶粉价格1740到手价12400群克隆这条信息₳YrJTYsK187o₳后打开手淘百草味零食大礼包-千玺版价格299到手价138群克隆这条信息$2vxrYsKaK

2020-03-22

平安哪些产品性价比高?

收起更多回答(2) 我来答扫描二维码下载下载百度知道APP,抢鲜体验平安有全都的产品性价比有的是 很高的,关键有你在适合哪个产品,那个产品可是我性价比最高的,适合此人 的

2020-03-22

求推荐几款性价比高的手机!

1.屏幕:5.8英寸(直角)/5.6英寸(圆角)双曲面SuperAMOLED屏幕,分辨率为2220x101000(FHD+)。3.外壳颜色:谜夜黑、勃艮第红(具体以销售为准)。

2020-03-21