Connection to Database

Hi all,

when we load data from a database is the connection only opened for the loading and closed afterwards or do we by default keep a certain amount of connections open to the DB?

A customer asked this, because if we keep the connection open for longer, we might block other tools or people also using the DB.

Thanks for some clarification.