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.

Hi Vio,

to my understanding, we open and close a connection every time we want to read data from an external database. Beware that I did not explicitly check every case.

Best
Stefan