Hi All,
When connecting with a database that you may be interacting with multiple times during a process (storing config data on DB instead of excel configs, writing log data to DB etc., extracting/updating data from DB tables) Is it best practice to open the DB connection just once in init state of the Framework and then close it in end state or open and close the connection each time you want to interact with the DB so you aren’t leaving the connection open for potentially a long time?
Thanks all,