Local vs Remote Database Access: A Performance Test

An IBM Redpaper publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 29 December 2005

  1. .PDF (0.3 MB)

Share this page:   

IBM Form #: REDP-4113-00


Authors: Nin Lei, Leticia Cruz and Victor Chao

    menu icon

    Abstract

    When tuning a database for better performance, one area to examine is the proximity of the database to the application. Can the database be located on the same server as the application? Will a database server located far away from the application server cause performance degradation? To answer these questions, we conducted a series of measurements at the IBM zSeries Benchmark Center to determine performance impact based on the distance between the application and database servers. This paper discusses the results of our tests.

    Table of Contents

     

    Others who read this also read