Database Connections Time to Close

Ignition
,
1

Hello,

I have a script that runs once every month and adds 120 rows to the DB table. Normally, the connections to the DB sits around 100. After running the script, it’s sitting at a round 220. However, I know that these connections will not be used again for a while and they’ll eventually time out.

How long is the connection close timeout, and is it configurable?
If not, is there a way to close the connection manually?

2

There does exist some system functions that may handle what you are looking for. I have included a link here.

system.db.closeTransaction - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)