[jboss-user] [Performance Tuning] - JNDI datasource connection pooling

[lorenz.fischer]

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#4070164

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4070164