1.问题描述
批量更新RB_Amazon_Product_Base多个字段超时优化,没DBError_data.txt文件里每天出现多次
2.问题分析
批量更新导致超时,
3.解决方案
检查当前的批量更新数量是多少,减少批量更新的数量;
4.批量更新语句,不同于之前的更新一个字段,这个是更新多个字段:
UPDATE [RB_Amazon_Product_Base]
SET [IsOffShelf] = @IsOffShelf_1,
[UpdateTime] = @UpdateTime_1,
[IsVariation] = @IsVariation_1,
[VariantGroup] = @VariantGroup_1,
[ImageUrl] = @ImageUrl_1,
[RecommendedBrowseNodeName] = @RecommendedBrowseNodeName_1,
[TemplateID] = @TemplateID_1,
[ASINorItemID] = @ASINorItemID_1,
[BrowsePathByID] = @BrowsePathByID_1,
[AddAdminID] = @AddAdminID_1,
[AddAdminName] = @AddAdminName_1,
[ProductName] = @ProductName_1,
[ListingPrice] = @ListingPrice_1,
[PreDiscountPrice] = @PreDiscountPrice_1,
[DiscountSalesPrice] = @DiscountSalesPrice_1,
[DiscountStartTime] = @DiscountStartTime_1,
[DiscountEndTime] = @DiscountEndTime_1,
[TranslateStatus] = @TranslateStatus_1,
[OnShelfMode] = @OnShelfMode_1,
[BrandAddTitle] = @BrandAddTitle_1,
[ConstSeconds] = @ConstSeconds_1,
[ShelfRemark] = @ShelfRemark_1
WHERE [CustomerID] = @CustomerID_1
AND [OrderSourceSKUID] = @OrderSourceSKUID_1
AND [OrderSourceID] = @OrderSourceID_1
AND [OrderSourceSKU] = @OrderSourceSKU_1
UPDATE [RB_Amazon_Product_Base]
SET [IsOffShelf] = @IsOffShelf_2,
[UpdateTime] = @UpdateTime_2,
[IsVariation] = @IsVariation_2,
[VariantGroup] = @VariantGroup_2,
[ImageUrl] = @ImageUrl_2,
[RecommendedBrowseNodeName] = @RecommendedBrowseNodeName_2,
[TemplateID] = @TemplateID_2,
[ASINorItemID] = @ASINorItemID_2,
[BrowsePathByID] = @BrowsePathByID_2,
[AddAdminID] = @AddAdminID_2,
[AddAdminName] = @AddAdminName_2,
[ProductName] = @ProductName_2,
[ListingPrice] = @ListingPrice_2,
[PreDiscountPrice] = @PreDiscountPrice_2,
[DiscountSalesPrice] = @DiscountSalesPrice_2,
[DiscountStartTime] = @DiscountStartTime_2,
[DiscountEndTime] = @DiscountEndTime_2,
[TranslateStatus] = @TranslateStatus_2,
[OnShelfMode] = @OnShelfMode_2,
[BrandAddTitle] = @BrandAddTitle_2,
[ConstSeconds] = @ConstSeconds_2,
[ShelfRemark] = @ShelfRemark_2
WHERE [CustomerID] = @CustomerID_2
AND [OrderSourceSKUID] = @OrderSourceSKUID_2
AND [OrderSourceID] = @OrderSourceID_2
AND [OrderSourceSKU] = @OrderSourceSKU_2

3.解决方案
检查当前的批量更新数量是多少,减少批量更新的数量;