# Database Connections Time to Close

**URL:** <https://forum.inductiveautomation.com/t/database-connections-time-to-close/61957>\
**Category:** Ignition\
**Tags:** database, ignition81\
**Created:** [July 15, 2022, 4:28pm UTC](https://forum.inductiveautomation.com/t/database-connections-time-to-close/61957 "2022-07-15T16:28:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [July 15, 2022, 4:28pm UTC](https://forum.inductiveautomation.com/t/database-connections-time-to-close/61957/1 "2022-07-15T16:28:46Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![jonas.wells](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jonas.wells/32/24861_2.png) [@jonas.wells](https://forum.inductiveautomation.com/u/jonas.wells)\
**Post date:** [July 15, 2022, 6:19pm UTC](https://forum.inductiveautomation.com/t/database-connections-time-to-close/61957/2 "2022-07-15T18:19:54Z")

</div>

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)](https://docs.inductiveautomation.com/display/DOC81/system.db.closeTransaction)