Ticket #114 (closed 优化: fixed)

Opened 14 years ago

Last modified 14 years ago

pdl_product_front的数据准备的存储过程阻塞问题

Reported by: yuanhuoqing Owned by:
Priority: major Milestone: 2012报价库5.0
Component: 报价库 Version: 报价库5.0
Keywords: Cc:
Due Date: 10/07/2012

Description

pdl_product_front的数据准备的存储过程每5分钟执行一次，两次间隔的时间内执行不完，导致数据库阻塞。

Change History

comment:1 Changed 14 years ago by yuanhuoqing

李思亮(李思亮) 16:47:53
报价库处理product-front 表的那个东西，可不可以把时间拉长点
李思亮(李思亮) 16:48:18
数据库比较忙，会导致这个定时任务15分钟完不成
袁火青(袁火青) 16:52:46
嗯 现在是跟发布产品页面捆在一起执行 是为了避免新品的终端页出来而在产品的索引页上没有出来

comment:2 Changed 14 years ago by chenchongqi

进展如何了？

comment:3 Changed 14 years ago by yuanhuoqing

商城转pg和报价后台重构时对这个存储过程做了调整后阻塞情况好转很多。

Last edited 14 years ago by yuanhuoqing (previous) (diff)

comment:4 Changed 14 years ago by chenchongqi

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