User269602965 posted
depends on operational tempo and number of users.
small office app with user requesting a select here, insert there, update this,
and open and close not a problem
ramp that up to thousands of users coming at you with all kinds of requests
then staying open and adding things like connection pooling become more important