• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Static Connection??? is this right?

 
DC Dalton
Ranch Hand
Posts: 287
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was talking with a friend the other day about a site I am working on that uses a LOT of JDBC connections throughout it. I have a connection object I use that creates a connection every time one is needed & then closes it right after its done being used. I would normally use a connection pool but this host doesnt allow it (they havent got a clue)....Anyways, he said I should make my connection static. I kind of scratched my head on that one......why would you want everyone on the site using the same connection & having to wait for the connection to free up.......wouldnt that slow a site down to a crawl? I dont know if this is right or he's nuts....Can anyone shed some light on this cause it doesnt sound right to me. BTW, Im running MySQL for a db if that makes any diffence.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic