Ticket #29 (closed enhancement: fixed)

Opened 15 years ago

Last modified 15 years ago

相关接口导致数据库负载高

Reported by: chenchongqi Owned by: yuanhuoqing
Priority: major Milestone:
Component: 商家后台 Version:
Keywords: Cc:
Due Date:

Description

暂时屏蔽并换上简单规则的接口,新接口要优化后才能放上去

新接口规则:
(1)商情类型为新品、热卖(供应)、促销。
(2)商情状态为待审、通过。
(3)每商家限出1条。
(4)前两位为旗舰店商家,如没有旗舰店商家的相关商情,则按以下规则自动补位。
(5)优先购买该品牌服务的VIP商家,接着为其他VIP商家。
(6)按照商情发布时间降序排序,更新时间越靠近商城索引更新时间越靠前。

原接口规则:
按地区(2)商情状态为待审、通过。

(3)每商家限出1条。

Attachments

x.txt Download (1.6 KB) - added by chenchongqi 15 years ago.

Change History

Changed 15 years ago by chenchongqi

comment:1 Changed 15 years ago by chenchongqi

  • Status changed from new to assigned
  • Owner set to yuanhuoqing

comment:2 Changed 15 years ago by chenchongqi

新经销商报价页的商情露出导致数据库负载高的问题现作了如下优化:
1、旗舰店和vip商家的商情分开查
2、商情露出这个豆腐块单独拿出来做了缓存 避免了很多多余的查询 之前把这个豆腐块加到整页的缓存上了 分页、同品牌的产品过来时都查询了商情

comment:3 Changed 15 years ago by yuanhuoqing

  • spent_time set to 0.5
  • require_time set to 2011-06-23

优化处理上线后经dba观察数据库的负载平稳在12、13左右。

comment:4 Changed 15 years ago by chenchongqi

  • Status changed from assigned to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.