[jboss-user] [Performance Tuning] - Configuration of Datasource: min-pool-size and max-pool-size

[Peter Johnson]

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&containerType=14&container=2078]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100802/3e6f7065/attachment.html