Is there any suggestions, best practices of using SQL connections in KEMI?

Main idea - not to open connection to database in every route (cause it’s really expensive operation in terms of time) and reuse existing, for ex, created in some kind of startup route?

Or maybe use some else technique?