(@p1 bigint)select a.CustomerId,OrderSourceId,b.OrderSourceType,DevIdSellerId,AppIdMarketplaceId,
CertIdAccessKeyId, UserTokenSecretAccessKey,MerchantToken,EubApiPassword,a.IsActive
from RB_OrderSource_API a inner join RB_OrderSource b
on a.OrderSourceID=b.ID
WHERE a.CustomerID =@p1
没加nolock 大并发查询 互相阻塞，导致erp库主从同步延迟！ 另外不建议在日志表大批量插入数据时使用日志表用于大并发业务，容易连串阻塞。
insert bulk RB_OrderSource_Log ([CustomerID] Int, [LogTableName] VarChar(50) COLLATE Chinese_PRC_CI_AS, [LogTableID] Int, [Remark] NVarChar(4000) COLLATE Chinese_PRC_CI_AS, [AdminID] Int, [UserName] NVarChar(50) COLLATE Chinese_PRC_CI_AS, [AddTime] DateTime, [LogType] NChar(10) COLLATE Chinese_PRC_CI_AS)
[期望]
