aspose file tools*
The moose likes JDBC and the fly likes Question on connection pool size. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Question on connection pool size." Watch "Question on connection pool size." New topic
Author

Question on 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Question on connection pool size.