wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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: 5812
    
    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: 9956
    
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Maximum pool size for Database connection Pooling
 
Similar Threads
increase database connection
connpool_max_limit help
Help!!!!!! how to set Connection Pooling
Increasing the Maximum Connection pool size
how can we restrict no of user to get Connection object dynamically?