• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

9. Case Studies > Database Connection Pool Growth Limits Performance

Database Connection Pool Growth Limits Performance

Delays in web site response seem to correlate with periods of growth in the JDBC connection pool. To prove a causal relationship between delays and pool growth, two load tests are done. First, the connection pool is set to 10 connections. The web site is hit with 94 web test clients all within about 1 second. The start and stop times of all 94 clients are recorded, as is the growth of the connection pool over time. Figure 9-5 shows the results. The connection pool size is on the lefthand vertical axis and the web test client number is on the righthand vertical axis. Time in seconds is on the horizontal axis, but starts at about 628 rather than 0 because of the way the times were recorded in the test clients.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint