Analysis of Query Method's Performance in the Browser/Server

  • REN Zhi-bo ,
  • BIAN Xiao-fan
Expand

Online published: 2001-02-25

Abstract

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.

Cite this article

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

References

[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.
Outlines

/

〈 〉