电子商务网站访问性能研究

华中科技大学硕士学位论文电子商务网站访问性能研究姓名：冯平申请学位级别：硕士专业：软件工程指导教师：黄立群20050401II“”WebWebCPUWebCPUCPUIIIAbstractThedifferencebetweentheelectroniccommerceWebstationandthecommonWebstationisthattheformeris“commerce”Webstation.ThepurposetoestablishtheelectroniccommerceWebstationistoobtainthepotentialeconomicprofit.OnthebaseofstudyingtheelectronicWebstationapplication,thethinkingofconsideringtheuser'saccessingspeedandthestrategyofperformanceoptimizationincliningtotheuserarebroughtforward.TheexistingtechnologiesareappliedtotheprocessofWebstationdesignonthisbase.ThroughtheresearchoftheperformanceoftheelectroniccommerceWebstation,thetwoaspectsofproblemsinfluencingtheWebstationaccessingspeedarediscussed:Webserverconfigurationanddatabaseserveraccessingspeed.RegardingWebserverconfiguration,andtoenhancetheelectroniccommerceWebstationaccessingperformance,somemeasuredcanadopted:morememoryandmoreCPUtimedistributedtoWebserver,higherfrequencyCPUadoptedormoreCPUadopted.AnditispointedthatitshouldinclinetotheuseraccessingperformancewhenweighingthecontradictionexistingbetweentheWebstationperformanceandthefinancing.Toimprovethedatabaseserveraccessingperformance,thedatabasestructuredesignandthedatabaseaccessingarestudied.Astodatabasestructuredesign,themethodthatstoretheimportantandhigh-frequencyaccessdatathroughmergingseveraltablestoonetablesandcombinedwithtemporarytableandthemethodthatintegerkeyisappliedarebroughtforward.Theexperimentindicatesthatthedatabaseaccessingspeedisimprovedbyadoptingtheabovemethods.Astodatabaseaccessingdesign,somemethodsareadopted:creatingindexesonthehigh-frequencyaccessedcolumns,adoptingstoreprocesses,storethemosthigh-frequencyaccesseddataintothememory,andsoon.Keywords:ElectronicCommercePerformanceOptimizationDatabaseDesignWebSiteAccessingSpeed111.11“”[1][2](ElectronicCommerceEC)Internet()[3]————[3][5][6]22(1.1)HTTPSQLHTML1.1WebWebHTTPWebSQLSQLWeb3()WebWeb()WEB()WEB31.21——3~52ApacheOracleIISSQLServerIISIISSQLServerMS.NETADO.NETSQLServerMS.NETSybasePowerdesigner9.5Powerdesigner4SQLPowerdesigner9.5Windows2000Windows20001.7GCPU256M10M/100M1.3“”()()“”——52GCPU1GCPU1.3WebIISIISWeb6WebSQLAdo.netDataset72WebWebWebWeb[8]2.1(InternetInformationServerIIS)“”NTWebIISIISIISIIS2.2IISIISCPU[9]1IISIISIISIISIISIIS\HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters\MemoryCacheSizeMemoryCacheSize04GB30720003MBIIS80“”2IISCPU1NT23NoneIIS312“”3“”“”4“OK”41(HTTP)WebNetBEUITCP/IPIPX2IIS3NT“”WindowsNT4ODBC95WebNTFS6SSLIISSSL()“/”:://www.hust.edu.cn/default.html(default.html)()“/”ahref=://www.hust.edu.cn/default.htmltitle=/a102.3CPUI/O[10]1CPUCPUCPU90%CPU50%CPUCPU;CPUCPUCPUCPUCPUCPU90%CPUCPUCPUCPU2UNIX/LINUXSWAP()3:SQL()SQLSQL3I/OI/OI/O1/OI/OI/O11UNIX/LINUXI/OI/OI/OI/O[11]2.4IISIIS——CPUIIS1(75%)[11]2IDE(2.5mb/s)→SCSI(3mb/s)→SCSI2(5mb/s)→SCSI2(10mb/s)→PCI(40mb/s)RAMRAIDRAID(RAID0)(RAID5)[12]3CPUCPUCPU124()2.5IISIISWebWeb1333.1(entityintegrity)(referentialintegrity)(userdefinedintegrity)()()()[11]143.21[18]2NF2NF[12]2NF2020400()()15VIEW1VIEW2()()()SQL:BatchCompletedEventClass()cpu(cpu/)reads(IO)writes(IO)Duration(/)SPID(ID)select*fromVIEW1select*fromVIEW23.1CPU()()VIEW1119046VIEW21617530173VIEW21753173VIEW11946CPU80162nf3.3[19]80%20%80%20%80%20%80/2080%20%20%80%20%VIEW2“select*fromVIEW2”()20%80%20%“_20”“_20”“”(80%)(20%)(3)()()80%20%80%1720%SQLServer3.4SQLServerTransactSQLMicrosoft®ActiveX®[1]12SQLServer34567982“”910111251218cpu121003.5char[n]2Table_intkey_int(/)data(char[20])Table_chrkey_chr(char[5]/)data(char[20])99999key_int199999key_chr“1”“99999”data“data_1”“data_99999”select*fromtable_intwherekey_int91000andkey_int90000select*fromtable_chrwherekey_chr91000andkey_chr90000193.2CPU()()table_chr156214103718table_int1644093CPU1644931562141371821393793(sysindexsdpage)I/O3.243.61CATV20543232213SybasePowerDesignerSQL(3.1)()()()()223.13.1()2376541“”2ADDMENBERTEMPCREATEPROCEDUREADDMENBERTEMPASBEGIN/*mebmannage_temp*/ifexists(select1fromsysobjectswherename='mebmannage_temp')droptablemebmannage_temp/*mebmannage_temp*/SELECTdbo.t_memberManage.*,dbo.password.pw_password,dbo.password.pw_question,dbo.password.pw_answer,24dbo.advancedperson.am_account,dbo.advancedperson.am_bank,dbo.advancedperson.am_bankaddress,dbo.advancedperson.am_sex,dbo.advancedperson.am_nation,dbo.advancedperson.am_nativeplace,dbo.advancedperson.am_remarkINTOmebmannage_tempFROMdbo.passwordINNERJOINdbo.t_memberManageONdbo.password.pw_memberserial=dbo.t_memberManage.mb_noINNERJOINdbo.advancedpersonONdbo.t_memberManage.mb_no=dbo.advancedperson.am_memberserialEND51261212SQLServer34“AddMemberTemp”567“”“”“add”“25”“execADDMENBERTEMPgo”8“”“”“addmembertemp”“…”“1”“0:00:00”“”“AddMemberTemp”3.7int264SQL2Dataset4.1SQLSQL(StructuredQueryLanguage,)SQLSQLSQL:SQL(DataDefineLanguage,DDL)(DataManageLanguage,DML)(DataControlLanguage,DCL)[42]DMLSQLDMLDML4:SELECTINSERTUPDATEDELETESQLSQL(DatabaseManageSystemDBMS)DBMSDBMSSQL4.21SQLServer27.[44]employee(lname)/[44][29]——“”228SQL“”“”“”“”[30]“”()——4.31SQL[45]Transact-S