In B/S model, there are two methods to query database. This paper use dynamic SQL to compare with store procedure, analysing the query efficiency of the two methods and the overload of Web server and sql server . It has value to project design.
REN Zhi-bo
,
BIAN Xiao-fan
. Analysis of Query Method's Performance in the Browser/Server[J]. Journal of Hebei University(Natural Science Edition), 2001
, 21(1)
: 94
-97
.
DOI: 10.3969/j.issn.1000-1565.2001.01.023
[1] Meier J D. Top Ten Tips:Accessing SQL Through ADO and ASP. Http://msdn.microsoft.com/library/default.asp? [OL]. URL=/library/periodic/period98/ado.htm 1998.
[2] Microsoft. Microsoft SQL Server 6.5 程序员指南 [M]. 北京:科学出版社 1997.
[3] Meier J D. I Cannot Stress It Enough--Load Test Your ASP Applica tion [OL]. http://msdn.microsoft.com/siteguide/write-us.asp?author=J%2ED%2E+Meier&area=Server+Technologies 2000.