外文翻译---改进ADO.NET性能.doc外文翻译---改进ADO.NET性能.doc

收藏

编号:201311172034057921    类型:共享资源    大小:101.50KB    格式:DOC    上传时间:2013-11-17
  
5
关 键 词:
教育专区 外文翻译 精品文档 外文翻译
资源描述:
附录1.英文资料ImprovingADO.NETPerformanceImproving.NETApplicationperformanceandscalabilitySummary:Thischapterprovidesprovenstrategiestohelpyoudesignanddevelopscalabledataaccesssolutions.Topicscoveredincludedifferenttechniquestopassdataacrossapplicationlayers,managingthedatabaseconnectionpool,optimizingstoredprocedurecalls,reducingdatasetserializationcost,techniquesforpagingthroughlargeresultsets,managingtransactions,handlingBLOBS,andmuchmore.ObjectivesOptimizeyourdataaccessdesign.ChoosebetweenDataSetsandDataReaders.Runefficientdatabasecommands.Passdatabetweenlayersefficiently.Performefficienttransactions.Optimizeconnectionmanagement.Evaluatethecostofpagingthroughrecords.Evaluatecriteriaforanalyzingdataaccessperformance.Applyperformanceconsiderationstobinarylargeobject(BLOB)manipulation.OverviewWell-designeddataaccesscodeanddataprocessingcommandsareessentialelementsforapplicationperformanceandscalability.Typically,thedatabaseisafocalpointforapplicationloadbecausethemajorityofapplicationrequestsrequiredatathatcomesfromadatabase.Thischapterprovidesprovenstrategiesfordesigningandimplementingdataaccesscodeforperformanceandscalability.HowtoUseThisChapterUsethischaptertoimprovetheimplementationofyourdataaccesscodeforperformanceandscalability.Togetthemostoutofthischapter,considerthefollowing:Jumptotopicsorreadbeginningtoend.Themainheadingsinthischapterhelpyoutoquicklyidentifyandthenlocatethetopicthatinterestsyou.Alternatively,youcanreadthechapterbeginningtoendtogainathoroughappreciationoftheissuesthataffectADO.NETperformance.Usethechecklist.Use"Checklist:ADO.NETPerformance"inthe"Checklists"sectionofthisguidetoquicklyviewandevaluatetheguidelinespresentedinthischapter.Usethe"Architecture"sectionofthischaptertounderstandhowADO.NETworks.Byunderstandingthearchitecture,youcanmakebetterdesignandimplementationchoices.UnderstandcoreADO.NETcomponents,suchasdataproviderobjectsandtheDataSetobject.Usethe"DesignConsiderations"sectionofthischaptertounderstandthehigh-leveldecisionsthatwillaffectimplementationchoicesforADO.NETcode.Measureyourapplicationperformance.learnaboutthekeymetricsthatyoucanusetomeasureapplicationperformance.Youhavetomeasureapplicationperformancesothatyoucanidentifyandresolveperformanceissues.Testyourapplicationperformance."Testing.NETApplicationPerformance"tolearnhowtoapplyperformancetestingtoyourapplication.Youhavetoapplyacoherenttestingprocessandanalyzetheresults.Tuneyourapplicationperformance."Tuning.NETApplicationPerformance"tolearnhowtoresolveperformanceissuesthatyouidentifythroughtheuseoftuningmetrics.TuneSQLServer.ReadChapter14,"ImprovingSQLServerPerformance"toensurethatyourMicrosoft®SQLServer™databaseisappropriatelyconfigured.ArchitectureADO.NETreliesondataproviderstoprovideaccesstotheunderlyingdatasource.Eachdataproviderexposesasetofobjectsthatyouusetomanageconnections,retrievedata,andupdatedata.Thecoreobjectsarethefollowing:ConnectionCommandDataReaderDataAdapterInaddition,ADO.NETprovidestheDataSetobject,whichprovidesadisconnectedcacheofdata.TheDataSetobjectdoesnotrequireaspecifictypeofdatasourceandisnottiedtotheunderlyingdatasourcethatthedatawasobtainedfrom.ThebasicADO.NETarchitectureisshowninFigure12.1.Figure12.1:ADO.NETarchitectureThefollowinglistoutlinesthepurposeofeachofthemainADO.NETobjects:Connection.Thisobjectrepresentsaconnectiontoadatabase.Command.ThisobjectrepresentsanSQLstatementthatisrunwhileconnectedtoadatasource.ThisobjectcanbeastoredprocedureoradirectSQLstatement.DataReader.Thisobjectretrievesaread-only,forward-onlystreamofdatafromadatabase.TheDataReaderobjectisdesignedforconnectedscenariosandoffersbetterperformancethanreadingdataintoaDataSetobjectattheexpenseoffunctionality.FormoreinformationabouthowtouseDataReaderobjectsandDataSetobjects,see"DataSetvs.DataReader"laterinthischapter.DataAdapter.ThisobjectchannelsdatatoandfromaDataSetobjectandtheunderlyingdatasource.TheDataAdapterobjectalsoprovidesenhancedbatchupdatefeaturesthatwerepreviouslyassociatedwiththeADORecordsetobject.DataSet.TheDataSetobjectrepresentsadisconnected,cachedsetofdata.TheDataSetisindependentoftheproviderandisnottiedtotheunderlyingdatasourcethatmighthavebeenusedtopopulateit.DataSetcaneasilybepassedfromcomponenttocomponentthroughthevariouslayersofanapplication,anditcanbeserializedasXML.YoushouldbeawareofthewayaDataSetisinternallyconstructedbecausetheDataSetcontainsapotentiallylargenumberofinternalobjects.ThismeansthatalargenumberofmemoryallocationsarerequiredtoconstructatypicalDataSet.ADataSetconsistsofoneormoreDataTableobjectstogetherwithDataRelationobjectsthatmaintaintablerelationshipinformation.EachDataTablecontainsDataRowobjectsandDataColumnobjects.ConstraintobjectsareusedtorepresentaconstraintthatcanbeenforcedononeormoreDataColumnobjects.NoteYoucanalsousetypeddatasetsthatderivefromthebasicDataSetclass.Typeddatasetsprovidebenefitsatbuildtimeandatruntime.Formoreinformation,see"TypedDataSets"laterinthischapter.DataView.AlthoughtheDataViewobjectisnotshowninFigure12.1,youcanuseaDataViewtosortandfilterdatainaDataTable.Thiscapabilityisoftenusedfordatabinding.AbstractingDataAccessADO.NETisdesignedaroundasetofgenericinterfacesthatabstracttheunderlyingdataprocessingfunctionality.Youcanusetheseinterfacesdirectlytoabstractyourdataaccesslayersothatyoucanminimizetheimpactofchangingthetypeofdatasourcethatyouuse.Abstractingdataaccessisextremelyhelpfulwhenyouaredesigningsystemswhereyourcustomerchoosesthedatabaseserver.ThecoreinterfacesprovidedbyADO.NETarefoundintheSystem.Datanamespace:IDbConnection.Thisisaninterfaceformanagingdatabaseconnections.IDbCommand.ThisisaninterfaceforrunningSQLcommands.IDbTransaction.Thisisaninterfaceformanagingtransactions.IDataReader.Thisisaninterfaceforreadingdatareturnedbyacommand.IDataAdapter.Thisisaninterfaceforchannelingdatatoandfromdatasets.Thevariousproviderobjects,suchasSqlConnectionandOleDbConnection,implementthesegenericADO.NETdataaccessinterfaces.Ifyoudecidetoprogramagainstthegenericinterfaces,beawareofthefollowingissues:Thereissomesmallcostassociatedwithavirtualcallthroughaninterface.Certainexpandedfunctionalityislostwhenyouusethegenericinterfaces.Forexample,theExecuteXmlReadermethodisimplementedbytheSqlCommandobjectbutnotbytheIDbCommandinterface.Thereisnogenericbaseexceptiontype,soyoumustcatchprovider-specificexceptiontypes,suchasSqlException,OleDbException,orOdbcException.Whenyouusethegenericinterfaces,youcannottakeadvantageofdatabase-specifictypesthataredefinedforthemanagedproviders;forexample,youcannottakeadvantageofSqlDbTypeinSqlClientandOracle-specifictypesintheOracleprovider.Usingspecificdatabasetypesishelpfulfortypecheckingandparameterbinding.PerformanceandScalabilityIssues
  人人文库网所有资源均是用户自行上传分享,仅供网友学习交流,未经上传用户书面授权,请勿作他用。
关于本文
本文标题:外文翻译---改进ADO.NET性能.doc
链接地址:http://www.renrendoc.com/p-97921.html

当前资源信息

4.0
 
(2人评价)
浏览:28次
英文资料库上传于2013-11-17

官方联系方式

客服手机:17625900360   
2:不支持迅雷下载,请使用浏览器下载   
3:不支持QQ浏览器下载,请用其他浏览器   
4:下载后的文档和图纸-无水印   
5:文档经过压缩,下载后原文更清晰   

相关资源

  • Thomas_Calculus_13th(托马斯微积分 13版)Thomas_Calculus_13th(托马斯微积分 13版)
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊2016】借助于电缆驱动系统改进工业机器人的静态性-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊2016】借助于电缆驱动系统改进工业机器人的静态性-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊2016】借助于电缆驱动系统改进工业机器人的静态性-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊2016】借助于电缆驱动系统改进工业机器人的静态性-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】最小化模式下料问题科林麦克迪尔米德-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】最小化模式下料问题科林麦克迪尔米德-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】组合机床行业现状与发展思考-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】组合机床行业现状与发展思考-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】自行航水器真正自治-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】自行航水器真正自治-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】自行航水器真正自治-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】自行航水器真正自治-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模具的设计与热分析-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模具的设计与热分析-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模的单浇口优化-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模的单浇口优化-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模的单浇口优化-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】注塑模的单浇口优化-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】主轴平衡力和曲轴弯曲应力的研究-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】主轴平衡力和曲轴弯曲应力的研究-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】轴对称降落伞形状的研究-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】轴对称降落伞形状的研究-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】轴对称降落伞形状的研究-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】轴对称降落伞形状的研究-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】中国乘用车燃料经济性标准的组成和影响-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】中国乘用车燃料经济性标准的组成和影响-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】指垫和平面之间的动态交互作用:实验和分析-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】指垫和平面之间的动态交互作用:实验和分析-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】指垫和平面之间的动态交互作用:实验和分析-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】指垫和平面之间的动态交互作用:实验和分析-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】直线电机高速数控切断机的发展-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】直线电机高速数控切断机的发展-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】直线电机高速数控切断机的发展-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】直线电机高速数控切断机的发展-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】支持机床系统的面向对象设计-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】支持机床系统的面向对象设计-中文翻译
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】支持机床系统的面向对象设计-外文文献[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】支持机床系统的面向对象设计-外文文献
  • [机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】振动镗孔与振动钻孔的研究-中文翻译[机械模具数控自动化专业毕业设计外文文献及翻译]【期刊】振动镗孔与振动钻孔的研究-中文翻译
  • 精品推荐

    相关阅读

    人人文库
    关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服客服 - 联系我们

    网站客服QQ:2846424093    人人文库上传用户QQ群:460291265   

    [email protected] 2016-2018  renrendoc.com 网站版权所有   南天在线技术支持

    经营许可证编号:苏ICP备12009002号-5