Re: Which exact DBI->connect method does Class-DBI call?

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

karjala_lists@xxxxxxx.xxx wrote:
> I'm using mod_perl (and Class-DBI 0.95) on my website and I need to know 
> which exact parameters Class-DBI uses to connect to the database.
> 
> ....
> This way a database connection will always be open and no time will be 
> lost in making a new connection during a webpage request.
> 
> Thanks,
> - Alexander

Alexander,

A couple of points.

1) CDBI creates a dbh with the parameters YOU choose, when you setup the 
  cdbi base class

2) Even if your dbh doesn't have the same parameters as the dbh you 
setup during mod_perl startup, your cdbi classes will only suffer the 
performance hit the first time one of your cdbi classes is called, after 
that, Apache::DBI will cache that (different) dbh for all future requests

Jay