Database Sql connection. When to close it?


i need to make a call to db within the “process state”.

I am using the REFramework. Each transaction takes about 25 seconds and I have about 1000 transactions per day.

My question is: is it necessary every time I arrive in the ref “process state” to use the activity Connect–>Run query–>disconnect? Or is it better to use connect for example in the init and disconnect in the end using the same connection string throughout the process state?

What is the best practice in these cases?

Thanks in advance


Disconnect to the Data Base in the end state.

We can connect to the data base in the initialization state. get the data from Get transaction and process it in the process transaction.