I have an application that is used daily by 20 people - each person runs the app on their own computer. It is entirely DB-driven (yeah, what's not).
Is it better to open the DB connection on program load and keep open until the application is closed OR
Is it better to open/close the connections only when needed?
What's better and what is the reason?
Is it better to open the DB connection on program load and keep open until the application is closed OR
Is it better to open/close the connections only when needed?
What's better and what is the reason?