Connection pool connect the largest number of the minimum number of connections how to set up each number can be increased so that the most efficient connection pool?

Abstract: In connection pool connect the largest number of the minimum number of connections how to set up each number can be increased so that the most efficient connection pool?

Tomcat5.5
Connection Pool: c3p0
Database oracle9i

MaxPoolSize = "100"
MinPoolSize = "1"
AcquireIncrement = "2"

How these three parameters can be set up to run the most efficient system? Is there any rough calculation methods, such as the number of connected cases, they were set to?
Also need to install or other parameters of what? Below is the configuration I
Auth = "Container"
Description = "DB Connection"
DriverClass = "oracle.jdbc.driver.OracleDriver"

MaxPoolSize = "100"
MinPoolSize = "1"
AcquireIncrement = "2"
Name = "jdbc/oracle9"
User = "test"
Password = "test"
Factory = "org.apache.naming.factory.BeanFactory"
Type = "com.mchange.v2.c3p0.ComboPooledDataSource"
JdbcUrl = "jdbc: oracle: thin: @ 192.168.1.2:1521: ora9i" />

That depends on what you use, such as weblogic, generally speaking we have to many app, and each is different app DataSource link to a different logic DataBase, the general 1-30,000 users, 10 Suffice it to a few of the links. whole if a mainframe links to more than 100 the number of words should consider clustering or load balancing.
If your host only one application, you only visit a DataBase, not more than 30, because although multiple physical links link in the application logic can be more opportunities, but to protect the physical link for more resources , if the overall situation into consideration, around 30 best

Do you mean 30 is the highest, then the minimum number of appropriate? How to calculate? AcquireIncrement set number of the best?

â†‘ Back

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.