File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Question on connection pool size." Watch "Question on connection pool size." New topic

Question on connection pool size.

surya sudhakar

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
I agree. Here's the link:
subject: Question on connection pool size.
It's not a secret anymore!