What is a database connection pool?

Question

Database

What is a database connection pool? For example, I have a class for working with a database. I just can't figure out whether it's worth moving the creation of a new connection into a separate method or pushing it into a constructor?
It's just that the class is part of the server code and it will be constantly accessed from the site, but it's not clear whether new connections will be created, if so, at what point?
And do they need to be closed explicitly?

Answer 1

What is a database connection pool?

Read here

Answer 2

In .net, the connection pool is implicitly implemented. When you call new XxxConnection(Sql,MySql, etc.) the connection is either created if there are no free ones or taken from the pool. Therefore, it is probably worth creating a connection every time it is needed and wrapping it in a using construct.
Here is the link on msdn