[步骤]

海外服务5   下面语句 每次 请求 数据容量为 3.6兆，建议 采用 缓存

 SELECT [ID],[CustomerID],[OrderSourceType],[OrderSourceName],[OrderSourceImage],[SendDeliveryEmail],[SendDeliveryEmailTitle],[SendDeliveryEmailTemplate],[OrderSourceCountry],[DefaultWareHouseID],[DefaultTransportID],[SaleAdminID],[SaleAdminName],[ServiceAdminID],[ServiceAdminName],[ServiceEmail],[SameAddressMergerPackage],[UpdateTrackNumberPlatform],[OrderNeedCheck],[IsActive],[AddAdminID],[AddAdminName],[AddTime],[UpdateTime],[IsPrintNote],[IsPrintPirckingOrder],[TrackingNOConfig],[DomainName],[TuanGouOrderType],[TuanGouCurrency],[ApiID],[ImgDomainName],[VATRatio],[ExchangeRateLoss],[SourceStatus],[CDNDomainName],[CDNImgDomainName],[IsB2CCustoms],[OrderSynCycle],[IsNoRules],[PriorityNum],[OrderSourceEmail],[IsDelete],[IsDownloadOrder],[IsGetTrackNo],[IsMarkDelivery],[IsReceiveMail],[IsSendMail],[RealShopName],[VATNumber],[LogisticsTemplateID],[VATRate],[CustomsPeopleManageID],[IsAutoDownLoadWishListing],[IsDownLoadOrderLoan],[OrderLoanStartTime],[RemovalOrderDefaultWareHouseID],[SaleVATRatio],[ReportEncoding],[ChildShopID],[SetShipDays],[IsBoutique],[PayPalAccountID],[OverseasWarehouseUpdatetime],[SenderTaxNumber],[WareHouseAccountType],[IsMainShop],[EORI],[ChannelPlatformStatus],[RemovalOrderTelephone],[ReasonWithException],[ReasonWithPause],[ReasonWithRemark],[IsNonIncludeTax],[IsStock],[StoreID],[StoreName],[CollectionChannelStatus],[IsGeneralIncome],[FBASaleAdminID],[FBMSaleAdminID] from RB_OrderSource(nolock) where CustomerID=1 and  OrderSourceType=1 and IsDelete=0 AND IsActive=1  ORDER BY ID ASC 

[结果]

[期望]

缓存保存，后面从缓存中读取，节约流量费