hi all,
i'm trying to find the optimal settings for the parameters min-pool-size and
max-pool-size for my jndi datasource which connects to a oracle database.
does anybody know of a good site, doc or forum post that describes those parameters
(thoroughly)?
as far as i'm concerned the min-pool-size defines the number of connections that (once
opened) stay open even if the connections are idle. the max-pool-size parameter defines
how many connections can be handled by the pool concurrently at max. so all the
connections between min and max-pool-size are closed (if idle for at least
idle-timeout-minutes) and reopened (if more than min-pool-size connections are required)
again.
on some site (unfortunately lost the link) i once read, that setting the min-pool-size
equal to the max-pool-size might result in a performance gain since jboss does not need in
any case to close/reopen database connections. does anybody have experience with that?
another question - given an unlimited amount of available connections - is there any
reason not to set the two parameters equal to each other; except for the fact, that there
might be max-pool-size connections to the database idling?
any hints are greatly appreciated :-)
cheers
lorenz
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4070164#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...