DenkzeitWiki

Connection Pooling

Creating a connection is expensive; it requires your application to connect to the database server, authenticate, and return a valid connection. [1]

• If connection-string is the same
• uses same Transaction!
  • security
  • consistency
• Warm-Up phase
  • Setting up the pool upon first connection.
    
  
  
• MicrosoftSQLServer does the pooling itself,
• with e.g. Oracle the client does the pooling
  
  
• William (Bill) Vaughn's Musings: Managing and Monitoring .NET Connection Pools
  
  
• http://www.sql-server-performance.com/sk_connection_pooling_myths.asp --SQL Server Connection Pooling Myths
• http://www.javaworld.com/javaworld/jw-10-2000/jw-1027-pool.html --Dive into connection pooling with J2EE
• http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp --Pooling in the Microsoft Data Access Components
• http://mail.python.org/pipermail/python-list/2003-October/187185.html --database connection pooling from mod_python app
  • http://mail.python.org/pipermail/python-list/2003-October/187265.html

• http://blog.gungfu.de/archives/2011/06/27/die-zwei-seiten-des-connectionpoolings/