Sunday, November 18, 2018

Why Are Connection Pools Needed?

Database connections are expensive to create and also to maintain. The reasons for this are many, including:

  • Establishing a network connection to the database server
  • Parsing the connection string information
  • Performing user authentication
  • Initialising the database connection in the database
  • Establishing transactional contexts