Peter Johnson [
http://community.jboss.org/people/peterj] replied to the discussion
"Configuration of Datasource: min-pool-size and max-pool-size"
To view the discussion, visit:
http://community.jboss.org/message/555495#555495
--------------------------------------------------------------
*>>50 users all time connected to the database*
Connected to the database, or connected to the application? There is a huge difference!
The 50 users will always be connected to the application, but only when a request is in
progress will a database connection be needed. As soon as the request is done, that
connection is no longer needed. As an example, if your 50 users all go to lunch at the
same time, then during the lunch hours there will be 50 idle connections - none will be in
use.
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/555495#555495]
Start a new discussion in Performance Tuning at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]