Re: CDBI and mod_perl

[prev] [thread] [next] [Date index for 2005/03/02]

On Wed, Feb 23, 2005 at 01:50:11PM -0500, Perrin Harkins wrote:
> On Wed, 2005-02-23 at 17:34 +0000, Addison, Mark wrote:
> > I still can't see why you would want to share the dbh
> > between the 2. It sounds down right dangerous to me!
> > What is wrong with letting the 2 sets of code manage their own
> > handles?
> 
> Very simple: it will kill the scalability of my application to have
> twice as many connections to the database open per apache child process.

I sincerely doubt you'll find this to be the case; an idling database
connection shouldn't require noticeable amounts of resources. For example,
MySQL AFAIK only maintains a small buffer per connection plus some tracking
info and everything else is shared.

If this isn't the case I'd be fascinated to see some figures to the contrary.

        -- 
            Matt S Trout            Brag sheet:    http://trout.me.uk/services.html
LAMP, Infrastructure        Contact:       services@xxxxx.xx.xx
   and Automation
     specialist                                       Do it once. Do it right.