Connection pooling

Question posted in Computer Software on 06 2010
Rate question difficulty level 0 Votes
What is connection pooling and what is it good for ?
 
 
2 Answers
 
In software engineering, a connection pool is a cache of database connections maintained by the database so that the connections can be reused when the database receives future requests for data. Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a database connection for each user, especially requests made to a dynamic database-driven website application, is costly and wastes resources. In connection pooling, after a connection is created, it is placed in the pool and it is used over again so that a new connection does not have to be established. If all the connections are being used, a new connection is made and is added to the pool. Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database.

credits : http://en.wikipedia.org/wiki/Connection_pool

06/21/2010
 
 
We have recently discovered that if you are using integrated authentication, pooling is based on the individuals connecting even though the connection string is exactly the same on all requests. But the connections will be pooled for each subsequent request by that user (assuming you don't run out of connections before the next request by that user).

Also, if you are able to connect using integrated authentication, you do not need to remember to pass user id to each stored procedure, but rather get it from the db connection directly using a SQL Function.

06/22/2010
 
 
Add an answer*
 
Your name
Email
 
Company: db@net
Location: Israel
database

add a question

arrow_blue


Now hiring!
Information Technology Development Program/Software Engineer
National Security Agency (NSA) 
Fort George G Meade, MD
To advance the development of Information Technology, NSA has created the new Information Technology Development Program ... 'Software development life cycle experience (e.g., software design, quality assurance, testing, planning,...
---------------------------
IT & Engineering Professionals w/ Poly
SRA International 
Herndon, VA
Business focuses on providing high-end information technology solutions and support to clients within the ... Architects ? Configuration Management Specialists ? Software Engineers ? Software Developers ? Geospatial...
---------------------------
IT Application Analyst
Saint Barnabas Health Care System 
Oceanport, NJ
projects. Participate in and provide leadership for development and support of automation initiatives. Research ... skills. Experience in w orking with and developing hospital information systems. Patient Accounting and/or registration...
---------------------------
IT Mgr Software Engineering
Apollo Group 
Phoenix, AZ
supervision and the software development guidelines and technology standards defined by Apollo Corporate IT, this ... Experience supervising and/or leading other professional level IT staff is required...
---------------------------
Senior Software Developer - Info Technology Job
Mercer 
Deerfield, IL
Senior Software Developer - Info Technology-DEE000C5 Description Mercer is the global leader for trusted Human Resources ... information, please visit us at: www.mmc.com/diversity. Job Information Technology/Software Development Primary Location...
---------------------------
Account Manager - IT Staff Augmentation/IT Consulting Services
TNT Staffing 
Emerson, NJ
for highly motivated, dynamic Information Technology (IT) Sales Professionals to join our growing IT Staffing ... and a passion for relationship building and business development. The right candidate will have a successful...
---------------------------
Software Development Manager 2 - Health IT
Northrop Grumman 
Providence, RI
Northrop Grumman is seeking an experienced Software Development Manager to join our team of qualified, diverse ... years of relevant experience - Experience with IT Project Development Lifecycle - Strong Medicaid/Medicare business...
---------------------------
Software Development Analyst 2 - Health IT
Northrop Grumman 
Providence, RI
Northrop Grumman Information Systems Sector is seeking a Software Development Analyst 2 to join our team of qualified, ... development life cycle (SDLC) in support of application software from design, development, testing, documentation...
View all jobs