小毛头的BLOG

有2个人从铁窗朝外忘去,一个人看到满地的泥泞,另一个人只看到满天的繁星

用户操作
[留言]  [发消息]  [加为好友] 
订阅我的博客
XML聚合    FeedSky
订阅到鲜果
订阅到Google
订阅到抓虾
huanghui22的公告
<!-- <DIV id=Layer1 style="Z-INDEX: 1; LEFT: 300px; WIDTH: 450px; POSITION: absolute; TOP: 125px; HEIGHT: 350px"> <OBJECT codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0 height=400 width=400 classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000><PARAM NAME="_cx" VALUE="10583"><PARAM NAME="_cy" VALUE="10583"><PARAM NAME="FlashVars" VALUE=""><PARAM NAME="Movie" VALUE="http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM NAME="Src" VALUE="http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM">http://www.hrtsea.com/bbs/Images/fish.swf"><PARAM NAME="WMode" VALUE="Transparent"><PARAM NAME="Play" VALUE="0"><PARAM NAME="Loop" VALUE="-1"><PARAM NAME="Quality" VALUE="High"><PARAM NAME="SAlign" VALUE=""><PARAM NAME="Menu" VALUE="0"><PARAM NAME="Base" VALUE=""><PARAM NAME="AllowScriptAccess" VALUE="always"><PARAM NAME="Scale" VALUE="ShowAll"><PARAM NAME="DeviceFont" VALUE="0"><PARAM NAME="EmbedMovie" VALUE="0"><PARAM NAME="BGColor" VALUE=""><PARAM NAME="SWRemote" VALUE=""><PARAM NAME="MovieData" VALUE=""><PARAM NAME="SeamlessTabbing" VALUE="1"> <embed src="http://www.hrtsea.com/bbs/Images/fish.swf" width="400" height="400" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" menu="false" wmode="transparent"></embed></OBJECT></DIV> --> <br><center><h2> </h2></center><br>QQ:99575165<br>MSN:<br>huanghui24@hotmail.com<br>来自: 上海市 <!-- 公告栏 --> <TD style="BORDER-RIGHT: #999 1px dotted; BORDER-TOP: #999 1px dotted; BORDER-LEFT: #999 1px dotted; BORDER-BOTTOM: #999 1px dotted"> <SCRIPT language=javascript> document.write ("<marquee scrollamount='1' scrolldelay='30' direction= 'UP' width='158' id='helpor_net' height='100' onmouseover='helpor_net.stop()' onmouseout='helpor_net.start()' Author:redriver; For more,visit:www.helpor.net>") document.write ("<h4><p align='center' style='color:#cccccc; font-family:黑体'>一分钟的你自己</p></h4>") document.write ("<p align='right' style='color:#0000FF;font-size:10px;'>2008-2-13</p> ") document.write ("<p style='font-size:11px;'>") document.write ("<br>最近事情比较多,有些朋友的邮件可能要晚些才能回哦~~~<br>") document.write (" <br>可以直接msn召唤我<br>") document.write ("</p>") document.write ("</marquee> ") </SCRIPT> </TD><!-- 公告栏结束 --> <br><br> <center><img src=http://nmc2.jy.js.cn/cgi-bin/counter.pl?id=csdn_blog_huanghui22&md=a11&ln=6&from=0&bd=$123;$200;$125></center> <HR> <Center> <OBJECT codeBase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0 height=150 width=150 align=middle classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000><PARAM NAME="movie" VALUE="http://www.hrtsea.com/bbs/Images/clock.swf"><PARAM NAME="quality" VALUE="high"><PARAM NAME="WMODE" VALUE="transparent"> <embed src="http://www.hrtsea.com/bbs/Images/clock.swf" width="150" height="150" align="middle" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" scale="noborder" bgcolor="#E4E8EF"></embed> </OBJECT></Center> <hr> <SCRIPT language=javascript> function getweather(t) { window.open("http://appnews.qq.com/cgi-bin/news_qq_search?city="+t, name="_self"); } </SCRIPT> <hr> <SCRIPT>var s="http://www.google.com/search?hl=zh-CN&lr=lang_zh-CN&q=";</SCRIPT> <hr> <!-- Blog日历表开始 --> <script language="javascript"> var diarydays="<2004-08-05><2004-08-09><2004-08-12><2004-08-17><2004-08-19><2004-07-14><2004-07-13><2004-07-08><2004-07-05><2004-07-04><2004-07-03><2004-06-27><2004-06-26><2004-06-25>"; </script> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <style> .calendarBigBorder { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; text-decoration: none; width: 170; background-color: #FFFFFF; font-size: 9pt;border:1px dotted #999; } .calendarTd { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #000000; background-color: #eeeeee; height: 18px; width: 11%; text-align: center;} .calendarMInput { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; text-decoration: none; background-color: #FFFFFF; height: 15px; border: 1px solid #666666; width: 19px; color: #0099FF;} .calendarYInput { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #0099FF; text-decoration: none; background-color: #FFFFFF; height: 15px; width: 34px; border: 1px solid #666666;} .calendarMonthTitle { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: normal; height: 24px; text-align: center; color: #333333; text-decoration: none; background-color: #eeeeee; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-bottom-style: none; border-top-color: #999999; border-right-color: #999999; border-bottom-color: #999999; border-left-color: #999999;} .calendarNow { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: bold; color: #000000; background-color: #C0C9D3; height: 18px; text-align: center;} .calendarDaySat { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #333333; text-decoration: none; background-color: #eeeeee; text-align: center; height: 18px; width: 12%;} .calendarDaySun { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; color: #333333; text-decoration: none; background-color: #eeeeee; text-align: center; height: 18px; width: 12%;} .calendarLink { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; font-weight: normal; color: #333333; text-decoration: none; background-color: #E7E7F6; text-align: center; height: 18px;} .categoryTxt { font-family: "Arial", "Helvetica", "sans-serif", "宋体"; font-size: 9pt; line-height: 23px; color: #333333; text-decoration: none;} .categoryTable { border-right-width: 1px; border-bottom-width: 1px; border-right-style: solid; border-bottom-style: solid; border-left-style: none; border-right-color: #000000; border-bottom-color: #000000; border-top-width: 1px; border-top-style: solid; border-top-color: #71b99c;} </style> <SCRIPT LANGUAGE="JavaScript"> var months = new Array("一", "二", "三","四", "五", "六", "七", "八", "九","十", "十一", "十二"); var daysInMonth = new Array(31, 28, 31, 30, 31, 30, 31, 31,30, 31, 30, 31); var days = new Array("日","一", "二", "三","四", "五", "六"); var classTemp; var calendarHover="calendarHover"; var today=new getToday(); var year=today.year; var month=today.month; var newCal; //得到某月天数 function getDays(month, year) { if (1 == month) return ((0 == year % 4) && (0 != (year % 100))) ||(0 == year % 400) ? 29 : 28; else return daysInMonth[month]; } //得到当天时间信息 function getToday() { this.now = new Date(); this.year = this.now.getFullYear(); this.month = this.now.getMonth(); this.day = this.now.getDate(); } //生成日历 function Calendar() { newCal = new Date(year,month,1); //当前月的第一天 today = new getToday(); var day = -1; //用来判断日历中是否为当天 var startDay = newCal.getDay(); //当月开始时间 var endDay=getDays(newCal.getMonth(), newCal.getFullYear());//当月结束时间 var daily = 0; //用来生成日历中的天数值 if ((today.year == newCal.getFullYear()) &&(today.month == newCal.getMonth())) day = today.day; var caltable = document.all.caltable.tBodies.calendar; //得到日历表格的集合 var intDaysInMonth =getDays(newCal.getMonth(), newCal.getFullYear()); //得到当月天数 //生成日历 for (var intWeek = 0; intWeek < caltable.rows.length;intWeek++) for (var intDay = 0;intDay < caltable.rows[intWeek].cells.length;intDay++) { var cell = caltable.rows[intWeek].cells[intDay]; //得到单元袼 //生成字符串用于判断当天是否有日志 var montemp=(newCal.getMonth()+1)<10?("0"+(newCal.getMonth()+1)):(newCal.getMonth()+1); if ((intDay == startDay) && (0 == daily)){ daily = 1;} var daytemp=daily<10?("0"+daily):(daily); var d="<"+newCal.getFullYear()+"-"+montemp+"-"+daytemp+">"; //选择样式 if(day==daily) cell.className="calendarNow"; else if(diarydays.indexOf(d)!=-1) cell.className="calendarLink"; else if(intDay==6) cell.className = "calendarDaySat"; else if (intDay==0) cell.className ="calendarDaySun"; else cell.className="calendarTd"; //生成值 if ((daily > 0) && (daily <= intDaysInMonth)) { cell.innerText = daily; daily++; } else cell.innerText = ""; } document.all.year.value=year; document.all.month.value=month+1; } function subMonth() { if ((month-1)<0) { month=11; year=year-1; } else { month=month-1; } Calendar(); } function addMonth() { if((month+1)>11) { month=0; year=year+1; } else { month=month+1; } Calendar(); } //得到响应事件 function getDiary() { var mon=(newCal.getMonth()+1)<10?("0"+(newCal.getMonth()+1)):(newCal.getMonth()+1); var day=event.srcElement.innerText<10?("0"+event.srcElement.innerText):(event.srcElement.innerText); var d="<"+newCal.getFullYear()+"-"+mon+"-"+day+">"; if ("TD" == event.srcElement.tagName) if (("" != event.srcElement.innerText)&&(diarydays.indexOf(d)!=-1)) { diary.location="/foxmail/archive/"+newCal.getFullYear()+"/"+mon+"/"+day+".aspx"; window.location.href = diary.location; } } function setDate() { if (document.all.month.value<1||document.all.month.value>12) { alert("月的有效范围在1-12之间!"); return; } year=Math.ceil(document.all.year.value); month=Math.ceil(document.all.month.value-1); Calendar(); } </SCRIPT> <table border="0" cellpadding="0" cellspacing="1" class="calendarBigBorder" id="caltable" width="200"> <thead> <tr align="center" valign="middle"> <td colspan="7" class="calendarMonthTitle"> <input name="year" type="text" class="calendarYInput" size="3" maxlength="4" onkeydown="if (event.keyCode==13){setDate()}" onkeyup="this.value=this.value.replace(/[^0-9]/g,'')" onpaste="this.value=this.value.replace(/[^0-9]/g,'')">年 <input name="month" type="text" class="calendarMInput" size="1" maxlength="2" onkeydown="if (event.keyCode==13){setDate()}" onkeyup="this.value=this.value.replace(/[^0-9]/g,'')" onpaste="this.value=this.value.replace(/[^0-9]/g,'')">月 [<a onClick="addMonth()" href="javascript:;">下月</a>] [<a onClick="subMonth()" href="javascript:;">上月</a>]</td> </tr> <tr align="center" valign="middle"> <SCRIPT LANGUAGE="JavaScript"> document.write("<TD class=calendarDaySun id=diary>" + days[0] + "</TD>"); for (var intLoop = 1; intLoop < days.length-1; intLoop++) document.write("<TD class=calendarTd id=diary>" + days[intLoop] + "</TD>"); document.write("<TD class=calendarDaySat id=diary>" + days[intLoop] + "</TD>"); </SCRIPT> </TR> </thead> <TBODY border=1 cellspacing="0" cellpadding="0" ID="calendar" ALIGN=CENTER ONCLICK="getDiary()" onmouseup=document.selection.empty() oncontextmenu="return false" onselectstart="return false" ondragstart="return false" onbeforecopy="return false" oncopy=document.selection.empty() onselect=document.selection.empty()> <SCRIPT LANGUAGE="JavaScript"> for (var intWeeks = 0; intWeeks < 6; intWeeks++) { document.write("<TR style='cursor:hand'>"); for (var intDays = 0; intDays < days.length;intDays++) document.write("<TD class=calendarTd onMouseover='{classTemp=this.className;this.className=calendarHover}' onMouseOut='this.className=classTemp'></TD>"); document.write("</TR>"); } </SCRIPT> </tbody> </table> <script LANGUAGE="JavaScript"> Calendar(); </script> <!-- Blog日历表结束 -->
文章分类
ORACLE讨论组
AskTom
CNOUG
ITPUB
ORACLE文章索引
存档

原创  网站性能优化解决方案 收藏

 
一、性能参数:
1、 吞吐量
2、 响应时间
3、 执行时间
4、 可伸缩性
 
二、性能优化方案:
编号
方案
说明
状态
1
在部署应用程序时,应该关闭Debug模式,这将有效提高应用程序性能(web.config文件的debug=false)
 
 
2
在部署应用程序时,使用RELEASE模式进行编译发布,优化程序资源!
 
 
3
尽量避免使用throw Exception,减少额外的开销
 
提供用户一个友好的出错页面
protected void Application_Error(Object sender, EventArgs e)
{
     …….
              Application["error"] = error;
              Response.Redirect("MyErrorPage.aspx");
}
由于捕获的异常,所以性能提升不大,但提供了统一的友好的出错信息页面
4
对适当的动态页面进行页面级缓存<%@ OutputCache Duration="60" VaryByParam="*" %>,提高访问速度!
 
两种情况:
1.       按照参数不同,进行不同版本的缓存
2. 按照URL不同,进行不同版本的缓存
例如:
 
Aspx页面中:
<%@ OutputCache Duration="300" VaryByParam="id" VaryByCustom="ceshi" %>
 
Global.asax中:
public override string GetVaryByCustomString(HttpContext context, string arg)
{
     if (arg == "ceshi")
     {
         string s_cs=Request.Url.ToString();
         return Request.Url.ToString() ;
     }
     return base.GetVaryByCustomString( context, arg);
}
5
尽量使用存储过程完成数据操作
 
 
6
对于只读的数据访问, 使用DateReader代替DataSet
 
 
7
关闭不必要的ViewState
使用 ViewState 时,每个对象都必须先序列化到 ViewState 中,然后再通过回传进行反序列化,因此使用 ViewState 并非是没有代价的。<input type="hidden"
没有进行加密,ViewState 只是进行了 Base64 编码
每个控件(在标记上) <asp:datagrid EnableViewState="false" ?/>
每个页面(在指令中) <%@ Page EnableViewState="False" ?%>
每个应用程序(在 web.config 中) <Pages EnableViewState="false" ?/>
 
 
8
调整数据库SQL语句
前提:需要在完全理解业务逻辑的情况下
 
9
调整索引
 
 
 
 
 
 
 
 
 
 
 
小测试,说明索引的重要性,虽然执行时间只是从3毫秒降到了0毫秒,但只是对于测试环境单用户而言,当成千上万的用户并发操作,造成服务器资源竞争激烈(内存IO/磁盘IO/CPU的上下文切换),CPU的执行时间应该会以几何级的速度增长!
 
select count(*) from dbo.公交
--12120笔记录
 
/*------目前没有索引的状况
       Table Scan 全表扫描
       逻辑读 256 次
        执行时间 3 毫秒-------*/
set showplan_all on
go
select * from dbo.公交 where city='宣城'
go
set showplan_all off
go
 
|--select * from dbo.公交 where city='宣城'
 |--Compute Scalar(DEFINE:([公交].[LineStop]=[公交].[LineStop]))
     |--Table Scan(OBJECT:([CQ20].[dbo].[公交]), WHERE:([公交].[city]=Convert([@1])))
 
set statistics io on
go
select * from dbo.公交 where city='宣城'
go
set statistics io off
go
 
表 '公交'。扫描计数 1,逻辑读 256 次,物理读 0 次,预读 0 次。
 
set statistics time on
go
select * from dbo.公交 where city='宣城'
go
set statistics time off
go
 
SQL Server 执行时间:
   CPU 时间 = 0 毫秒,耗费时间 = 3 毫秒。
/*-----------------创建city字段的索引-------------------*/
CREATE
 INDEX [idx_city] ON [dbo].[公交] ([city])
 
 
/*------建立索引后的状况
       Index Seek 索引扫描
       逻辑读 9 次
       执行时间 0 毫秒 -------*/
set showplan_all on
go
select * from dbo.公交 WITH(INDEX=idx_city) where city='宣城'
go
set showplan_all off
go
 
|--select * from dbo.公交 WITH(INDEX=idx_city) where city='宣城'
       |--Compute Scalar(DEFINE:([公交].[LineStop]=[公交].[LineStop]))
       |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([CQ20].[dbo].[公交]))
            |--Index Seek(OBJECT:([CQ20].[dbo].[公交].[idx_city]), SEEK:([公交].[city]='宣城') ORDERED FORWARD)
 
set statistics io on
go
select * from dbo.公交 WITH(INDEX=idx_city) where city='宣城'
go
set statistics io off
go
 
表 '公交'。扫描计数 1,逻辑读 9 次,物理读 0 次,预读 0 次。
 
SQL Server 执行时间:
   CPU 时间 = 0 毫秒,耗费时间 = 0 毫秒。
 

发表于 @ 2007年07月10日 14:42:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:[Oracle]体系结构(一)--概述 | 新一篇:小毛头的SEO实验

  • 发表评论
  • 评论内容:
  •  
Copyright © huanghui22
Powered by CSDN Blog