Local vs Remote Database Access: A Performance Test
An IBM Redpaper publication
Note: This is publication is now archived. For reference only.
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.