MCV - actually that might be the reason why I posted this question. I was thinking if there is some way things like this are done. As I'm not too familiar with MCV so I wouldn't know?

This would also answer questions of few others...

As I use sessions to see who's logged in, usually connection is made (in cgiapp_init sub of main module which is called before anything else is executed) on start-up. So I'm not sure if what you are proposing is possible? Anyway the disconnect is called by destructor of my module (DBIx::Handy)...