Skip to main content
Article thumbnail
Location of Repository

Performance of Database Driven Network Applications from the User Perspective

By Shanyu Tang, Huang YongFeng and Yau Jim Yip

Abstract

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

Topics: HF, QA76
Publisher: KSII
Year: 2009
OAI identifier: oai:eprints.hud.ac.uk:10336
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://dx.doi.org/10.3837/tiis... (external link)
  • http://www.itiis.org/ksii/acom... (external link)
  • http://www2.hud.ac.uk/staffpro... (external link)
  • http://eprints.hud.ac.uk/id/ep... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.