aspose file tools*
The moose likes EJB and other Java EE Technologies and the fly likes Connection pool size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Connection pool size" Watch "Connection pool size" New topic
Author

Connection pool size

surya sudhakar
Greenhorn

Joined: Jun 11, 2002
Posts: 18
Hi all,
I want to use the Connection pooling and Datasourace support given by JDBC in my project. I am configuring and looking up the Datasource in IBM websphere. What are the various points to be considered to decide the size of the pool. In my application I have both real-time as well as the batch updates to the database. In case of batch it may take around 3-5 minitues to complete the batch. In such a case if I go for a pool of less size(around 10) then I think for that duration of that time the conenction will on hold(I think). In such a case if so many clients initialize the batch then all the connection will be on hold, so, the responce time will gets reduced. In such a condition, how can I ensure that the response time is less with the use of Connection pool.
Thanks in advance
Sudhakar
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Why not create two separate Connection Pools? One for web requests and one for the batch processes.
This would be my approach due to the vastly different requirements of the two types of operations.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Connection pool size