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

Ruchir Choudhry [http://community.jboss.org/people/ruchirc] replied to the discussion "Configuration of Datasource: min-pool-size and max-pool-size" To view the discussion, visit: http://community.jboss.org/message/555973#555973 -------------------------------------------------------------- +Hello Emili,+ + + +Max and Min connection size  can become counter productive if not+ +set properly++, as when the server starts it reserves the connection(Handle) to the  DB in active state.Its also consumes resources as more thread is allocated to the server and hence more objects is on the stack and hence it will use more RAM/CPU. You need to also check the max connections allowed in the DB. Please check the timeout for these connections too.+ + + +Its a good practice to start with a lowere number, like 10 min and 60 max, see how the system behaves.+ + + +You have also mentioned that you have 50 concurrent users: In response to that, the algorithm in the J2EE container dose the hashing and rehashing of the connections, some times it reuses the connections too, its also dependent on  DB connection timeout both from J2EE container and from the DB.+ + + +Thus you have to check all these before coming to a right configuration.+ +Let me know if you are not cleare with anything + + + +Thank You,+ +Ruchir+ -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/555973#555973] Start a new discussion in Performance Tuning at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]