Re: CDBI and mod_perl

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

At 03:54 2005-03-02, Matt S Trout wrote:
> > 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.

But for example dedicated Oracle connections require huge amounts of memory 
in comparison. If the number grows beyond a certain point you need to 
switch to shared connections (MTS), and that's generally considered 
something to avoid (it fragments some of the logging information among 
other things, which makes the SQL harder to profile).

So sometimes it's important to keep the number of connections down, 
sometimes it's not.


/J

-------- ------ ---- --- -- --  --  -     -     -        -          -
Johan Lindström    Sourcerer @ Boss Casinos   johanl AT DarSerMan.com

Latest bookmark: "TCP Connection Passing"
http://tcpcp.sourceforge.net/
dmoz: /Computers/Programming/Languages/JavaScript/ 12