DBI-dev , can you please take a look and opine? Thanks a lot !! Manikantan
_____________________________________________ From: Manikantan, Madhunapanthula_Naaga Sent: Saturday, January 26, 2013 1:31 AM To: 'dbi-us...@perl.org' Subject: Handling idle database connections Hello dbi-users, I have a ton of PERL scripts that open a database connection, do some database related work for 5 to 10 mts and go on with other work for 2 to 3 days. This means, the database connection will be idle after 5 mts but still exists for 2-3 days. This can potentially choke my server once all the available threads are consumed. I think the right approach is for the developer to disconnect once he is done with database work. Since I have no control over the scripts, I want to explore the below. I was wondering if there is any option to DBI that will say " if the connection is idle for say 'X' mts disconnect automatically and set state accordingly. On subsequent call to $dbh it can check the state and re-establish connection as necessary". This will alleviate lot of my issues and any help/suggestion in this regard is greatly appreciated !!! Thanks a lot !!! Manikantan.
