Search:
Computing and Library Services - delivering an inspiring information environment

Performance of Database Driven Network Applications from the User Perspective

Tang, Shanyu, YongFeng, Huang and Yip, Yau Jim (2009) Performance of Database Driven Network Applications from the User Perspective. KSII Transactions on Internet and Information Systems, 3 (3). pp. 235-250. ISSN 19767277

[img] PDF
TIIS_Vol3No3P2Jun2009.pdf - Published Version
Restricted to Registered users only

Download (414kB)

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).

Item Type: Article
Subjects: H Social Sciences > HF Commerce
Q Science > QA Mathematics > QA76 Computer software
Schools: School of Computing and Engineering
School of Computing and Engineering > High-Performance Intelligent Computing
School of Computing and Engineering > High-Performance Intelligent Computing > Information and Systems Engineering Group
Related URLs:
Depositing User: Graham Stone
Date Deposited: 10 May 2011 09:32
Last Modified: 10 May 2011 09:32
URI: http://eprints.hud.ac.uk/id/eprint/10336

Downloads

Downloads per month over past year

Repository Staff Only: item control page

View Item View Item

University of Huddersfield, Queensgate, Huddersfield, HD1 3DH Copyright and Disclaimer All rights reserved ©