1. 获取2天内已打印未发货包裹缓存到Redis
2. Redis有效时间设置1天
3. 服务设置4个线程
任务描述
需求描述
1.问题原因：查询订单表超时
2.报错代码如下：
CODE:N1847034
Error:11_-2_0_-2146232060
SQL:SELECT ProductNumber,
OrderCode,IsFirstDeliver,IsStockOrder
FROM RB_OrderInfo (NOLOCK)
WHERE CustomerID = @CustomerID
AND OrderCode IN(SELECT ITEM FROM CharSplitForIn(@OrderCodes,','))
PARAMS:@CustomerID = 1 ,@OrderCodes = 202208250905125453678 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
3.优化方案：
将已打印或者已拣货订单的字段ProductNumber,OrderCode,IsFirstDeliver,IsStockOrder 缓存到服务端，
每次称重优先从缓存里面获取该数据。发货之后将该缓存异步清理。
验收标准
暂无
备注：
1、可缓存的包裹数据查询
SELECT op.ID AS PackageID,oi.ProductNumber,oi.OrderCode,oi.IsFirstDeliver,oi.IsStockOrder FROM RB_OrderInfo oi(NOLOCK)
INNER JOIN RB_Procurement_Order_Package op(NOLOCK) ON op.MergerPackageNo=oi.OrderCode AND op.CustomerID=oi.CustomerID
LEFT JOIN RB_Procurement_Order_Package_RedisInfo opr(NOLOCK) ON op.ID=opr.PackageID AND op.CustomerID=opr.CustomerID AND opr.IsExecuteWhenPackageWeight=1
WHERE op.PackageState=2 AND op.PrintTime>='2022-10-08 00:00:00' AND oi.CustomerID=1 AND ISNULL(opr.PackageID,0)=0
2、包裹称重缓存数据查询
select * from RB_Procurement_Order_Package_RedisInfo(nolock)