本文介绍通过技术升级、瓶颈定位、优化数据库连接管理、转换动态页面为静态页面、使用全文检索、采用存储过程、内存管理、计算任务分布、遵循Web标准、增加资源等方式提高ASP.NET+SQL网站性能。
How to enhance the performance of ASP/ASP.NET+SQL web site?
问：如何提高ASP/ASP.NET+SQL网站性能？
1,Upgrade your tecnolgy from ASP to ASP dot net as possible as you can.
1，如果有条件，ASP技术应该尽快转换到ASP.NET技术。
2,First of all,you should find the 'bottle-neck'.It is recommanded to use MS ACT Projects as a powerful tool to test the efficiency of your applications.
2，首先要找到瓶颈因素。推荐MS的ACT Projects作为测试工具。
3,Create as fewer DB Connections as possible.Release the idle connections and manage all the connections in a connection-pool.
3，尽量减少数据库连接，释放无用连接，利用连接池来管理连接。
4,Those pages which are frequently visited with less inter-activity should be changed to static HTML format.
4，交互性不强，访问量大的页面可以动态生成静态页面来处理。
5,It is recormand to deal with mass blur serching through SQL-fullText .
5，海量的模糊查询建议采用MS的全文检索。
6,增删查改尽量采用存储过程，例如：分页显示。
6,Refer to SQL precedures as more as possible when you are trying to do operations to databases.EXP:Data Paging.
7，及时回收内存中的垃圾。
7,Clean up the rubbish in your memory in time.
8，利用访问量低峰完成沉重复杂的计算任务。
Distribute the complicatd computing jobs to the servers when there are less visitors on your websites.
8,Spend the time which less visitor to finish the hard and complex computation job .
9，采用web标准来优化和重构你的页面。
9,Reconstruct your pages under Web-standards.
10，增加带宽，服务器数量或提高服务器硬件水平，合理分担不同任务到其他服务器中。
10,Increase band width and server amounts or improve your hardware quality.And try to distribute jobs to more servers in case of emergency or mass visits.
问：如何提高ASP/ASP.NET+SQL网站性能？
1,Upgrade your tecnolgy from ASP to ASP dot net as possible as you can.
1，如果有条件，ASP技术应该尽快转换到ASP.NET技术。
2,First of all,you should find the 'bottle-neck'.It is recommanded to use MS ACT Projects as a powerful tool to test the efficiency of your applications.
2，首先要找到瓶颈因素。推荐MS的ACT Projects作为测试工具。
3,Create as fewer DB Connections as possible.Release the idle connections and manage all the connections in a connection-pool.
3，尽量减少数据库连接，释放无用连接，利用连接池来管理连接。
4,Those pages which are frequently visited with less inter-activity should be changed to static HTML format.
4，交互性不强，访问量大的页面可以动态生成静态页面来处理。
5,It is recormand to deal with mass blur serching through SQL-fullText .
5，海量的模糊查询建议采用MS的全文检索。
6,增删查改尽量采用存储过程，例如：分页显示。
6,Refer to SQL precedures as more as possible when you are trying to do operations to databases.EXP:Data Paging.
7，及时回收内存中的垃圾。
7,Clean up the rubbish in your memory in time.
8，利用访问量低峰完成沉重复杂的计算任务。
Distribute the complicatd computing jobs to the servers when there are less visitors on your websites.
8,Spend the time which less visitor to finish the hard and complex computation job .
9，采用web标准来优化和重构你的页面。
9,Reconstruct your pages under Web-standards.
10，增加带宽，服务器数量或提高服务器硬件水平，合理分担不同任务到其他服务器中。
10,Increase band width and server amounts or improve your hardware quality.And try to distribute jobs to more servers in case of emergency or mass visits.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
