• Post Reply Bookmark Topic Watch Topic
  • New Topic

connection pools

 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am fixing a web application which uses mostly jsp. I am inserting an applet to replace much of the broken function of one specific page. The page makes numerous database calls and, when implemented several people might be on the page at one time (several being maybe a dozen)
I had the crazy thought of implementing a connection pool (I have never done this before) I found some example and followed along but my question is this. If my connection pool class is called when the user hits the page then that is great for user 1 (and a bit of overkill) but once I have a dozen people on-don�t I now have a dozen connection pools and therefore made things worse?
Am I just wasting time anyway given such limited use?

Thanks
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36031
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Pat,
Is this connection pool on the server? If so, the server may already provide one.

Or is it in the applet? If this is the case, the connection pool won't help. Each applet would have it's own and nothing would be pooled.
 
Pat Peg
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, that was the clarification I was looking for.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!