Re: meaning of max pool size ?

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 10:01:48 -0700

Max Pool Size determines how many connections will be kept open (once
opened) in the pool. Generally, a normally loaded system should use about a
dozen connections. If a connection string is different than any existing
pooled string, a new pool is created. Each pool contains connections with
identical connection strings. If you change the connection string each time,
you'll get a new pool each time.

hth 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Plausible Indirection" <cg22165@yahoo.com> wrote in message 
news:7b9ebe1f.0409300853.391c7fc1@posting.google.com...
> I'm having a hard time finding something explicit which indicates
> whether Max Pool Size is intended to mean 'maximum number of
> connections within a pool, where distinct connection strings means
> distinct pools' or 'maximum total number of connections which can be
> pooled, regardless of how many different strings have resulted in
> different pools'.
>
> Can anyone clarify this for me?  The former seems to make more sense.
>
> Thanks,
> Chris

Relevant Pages

  • Re: gdb help: debugging a segfault in boost::shared_ptr
    ... I am developing a database connectivity plugin for the Remedy Action ... I've developed a database pool for the plugin so the time ... The pool will also check if the connections are ... Thread-safe means that shared_ptr handle ...
    (comp.os.linux.development.apps)
  • Re: determining max pool size
    ... the larger the pool size, the more requests can be server. ... 500 open connections to SQL server I awfully lot.... ... close the connection without even executing the sql statement). ...
    (microsoft.public.dotnet.framework.aspnet)
  • JNDI Connection Pool issue
    ... I have found something strange with the jdk jndi connection pool. ... If you do not iterate over all the results returned by the query, ... private static HashMap connections; ... SearchResult searchResult= ...
    (comp.lang.java.programmer)
  • Re: MaxPoolSize - Recommendations
    ... Perhaps the pool is not leaking, ... using connections efficiently. ... for average 80 concurrent users. ... Microsoft doesn't have any recommendations concerning "max pool size" ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: RSX-11M-Plus Pool questions
    ... The fact that these 4 PDP-11 systems are still running after 30 ... connections along with 1 VAX 4000 and several DECServer Terminal servers). ... I have read all the RSX documentation I can find relating to pool ... I think I have a good grasp on Secondary pool. ...
    (comp.os.vms)