• KSII Transactions on Internet and Information Systems
    Monthly Online Journal (eISSN: 1976-7277)

Performance of Database Driven Network Applications from the User Perspective

Vol. 3, No. 3, June 21, 2009
10.3837/tiis.2009.03.002, Download Paper (Free):

Abstract

An understanding of performance of database driven network applications is critical in combating slow performance of e-commerce web sites, besides efficient web page design, and high quality and well-maintained web server equipment. This paper describes a method of measuring performance from the user viewpoint, which can help enormously in making realistic assessment of true performance of database driven applications. The performance measurements were taken at user locations by using several specially designed JavaScript functions along with ASP scripts. A performance study is presented in this paper, comparing performance of data access using stored procedures with the traditional way of querying a database. It is generally believed that stored procedures have performance benefits as they are pre-compiled. However, our study shows that the data access approach using stored procedures provides significant benefits (by about 30%) over the traditional approach for querying a commercial MySQL database, only when retrieving a substantial amount of data (at least 10,000 rows of data).


Statistics

Show / Hide Statistics

Statistics (Cumulative Counts from December 1st, 2015)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article

[IEEE Style]
S. Tang, H. YongFeng, Y. J. Yip, "Performance of Database Driven Network Applications from the User Perspective," KSII Transactions on Internet and Information Systems, vol. 3, no. 3, pp. 235-250, 2009. DOI: 10.3837/tiis.2009.03.002.

[ACM Style]
Shanyu Tang, Huang YongFeng, and Yau Jim Yip. 2009. Performance of Database Driven Network Applications from the User Perspective. KSII Transactions on Internet and Information Systems, 3, 3, (2009), 235-250. DOI: 10.3837/tiis.2009.03.002.

[BibTeX Style]
@article{tiis:19817, title="Performance of Database Driven Network Applications from the User Perspective", author="Shanyu Tang and Huang YongFeng and Yau Jim Yip and ", journal="KSII Transactions on Internet and Information Systems", DOI={10.3837/tiis.2009.03.002}, volume={3}, number={3}, year="2009", month={June}, pages={235-250}}