Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Question on connection pool size.

 
surya sudhakar
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic