Ima::DBI and DBIx::Class::Storage::DBI both call ping() to check if
the database is alive before retuning a cached $dbh.

I'm curious if this is a smart approach for a very database-heavy
site, or if this might be a hold-over from the "morning after" problem
where site that were quiet all night would fail in the morning as
their connections had timed out.

Is there an advantage of calling checking $dbh->FETCH( 'Active' ) &&
$dbh->ping vs. just flagging that the dbh is dead on error and then
reconnecting next time a $dbh is needed?

Am I missing something obvious?





-- 
Bill Moseley
[email protected]
Sent from my iMutt

Reply via email to