Solution: Connection Pooling

• Application server manages DB connections

• Keeps a number of connections open

  • Each HTTP request that needs to issue a database command asks the pool for a connection
  • The connection is “busy” until command is processed
  • Connection is then returned to the connection pool

• Interesting issues

  • Max # of connections? Min # of connections?
  • Why not just keep max # allocated always?
  • What to do when max is hit?

Previous slide

Next slide

Back to first slide

View graphic version