posted 15 years ago
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.