Re: "Dynamic" database handles?

[prev] [thread] [next] [Date index for 2005/01/24]

Quoting Michael Graham <magog@xxxxxxxx.xxx>:
> I use something like the following code in my CDBI base class:
>
>     sub db_Main {
>          my $class = shift;
>          my ($dsn, $user, $pass) = 
> My::Config->get_config('dbi_connection_info');
>          my %attr = $class->_default_attributes();
>          return DBI->connect_cached($dsn, $user, $pass, \%attr);
>      }
>
>
> The above code is probably not very efficient, because each time db_Main
> is called, it has to fetch the config and attribute information.  And
> db_Main is called *very* frequently in Class::DBI land.
>

Hi Michael. :)

The other alternative to using pnotes is to have something like an ENV 
var that
won't be corrupted across apache children and use that to key into a config
module, returning already generated configs if they exist.  That cuts out 99%
of your inefficiencies.  Apache::DBI will be doing something similar for your
actual database handles, so "reconnecting" is a pretty cheap operation.

-jason gessner
    jason@xxxxxxxx.xxx