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 - Published Version
Restricted to Registered users only

Download (404kB)


    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 > Informatics Research Group
    School of Computing and Engineering > Informatics Research Group > XML, Database and Information Retrieval Research Group
    Related URLs:
    Depositing User: Graham Stone
    Date Deposited: 10 May 2011 10:32
    Last Modified: 10 May 2011 10:32

    Document Downloads

    Downloader Countries

    More statistics for this item...

    Item control for Repository Staff only:

    View Item

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