• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Question on connection pool size.

 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic