Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Single Connection Instance  RSS feed

 
Timothy Sam
Ranch Hand
Posts: 751
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys! Could you please evaluate some problems regarding having only a single Connection instance in your app? The app is intended to be used by the public and let's say we're having 5 visitors per second who are simultaneuosly accessing the site? Thanks!
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36393
453
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Timothy,
The main problem is that your connection becomes the bottleneck. Typically several things are going on at once in a web app and you don't want to process users one at a time. People typically use connection pooling to avoid this problem.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!