It's not a secret anymore!*
The moose likes JBoss/WildFly and the fly likes Maximum pool size for Database connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Maximum pool size for Database connection Pooling" Watch "Maximum pool size for Database connection Pooling" New topic
Author

Maximum pool size for Database connection Pooling

sanuji pillai
Greenhorn

Joined: Jul 05, 2010
Posts: 24
Hi,

I am using connection pooling using JBoss.Please let me know about maximum and minimum pool size need to be set.

Regards,
Sanuji Pillai
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5823
    
    7

That depends completely on your application and on the database. Never set max pool size to more connections than the database can handle. Set min pool size to what the app needs when it is mostly idle (has very few users).

The only way you can find out what those numbers are is to do some load testing, and also monitor the number of active connections of a period of time, such as every 5-15 minutes for a week or 2. After you do that you will have enough information to set the min and max pool sizes.


JBoss In Action
sanuji pillai
Greenhorn

Joined: Jul 05, 2010
Posts: 24
Thanks for your reply and its is valuable.

Suppose our working project has 50000 hits/minute and using oracle 10g.Then what may i put as max and min pool size in Jboss.
Please reply.

Regards,
Sanuji
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10069
    
163

sanuji pillai wrote:

Suppose our working project has 50000 hits/minute and using oracle 10g.Then what may i put as max and min pool size in Jboss.
Please reply.



Peter's previous reply already answers that, doesn't it?

[My Blog] [JavaRanch Journal]
sanuji pillai
Greenhorn

Joined: Jul 05, 2010
Posts: 24
Thank you very much.
 
jQuery in Action, 2nd edition
 
subject: Maximum pool size for Database connection Pooling