Single database connection vs database connection pool
My understanding of a connection pool is that multiple connections to the database hang around and a client application can use them in order to send queries to the database, without having to go through the cost of setting up a new TCP connection (handshake, etc). I want to understand a little bit more in depth about the limitations of using a singular connection in a multithreaded application, and in something like nodeJS.