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?