Re: [SURVEY] How many connections are in your pool?

[Mario Ds Briggs]

Not sure about 600, but i have heard of cases where the connection pool
size was so large, it brought down the DB server when the pools were
intialized.



                                                                           
             Clinton Begin                                                 
             <clinton.be...@gm                                             
             ail.com>                                                   To 
                                       iBatis Java Mail List               
             20/01/2009 19:13          <user-java@ibatis.apache.org>       
                                                                        cc 
                                                                           
             Please respond to                                     Subject 
             user-j...@ibatis.         [SURVEY] How many connections are   
                apache.org             in your pool?                       
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hi all,

I've been studying a few large enterprise applications and have noticed an
interesting trend... many of these apps have HUNDREDS of connections (like
600) available or even open in their connection pools...

Survey Questions:

  1. How many connections do you have available in your pool?
  2. And if you know, how many CPU cores are available on your database
server (or cluster)?
  3. If you have 2x or 3x more connections than you do CPUs, do you have a
reason that you could share?

Cheers,
Clinton