Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
10 years my ass and doesnt know what SQLProfiler is? What a looser.
Yup. This is never a good idea.
Where I come from, it is called "putting your dick on the table".
He got his chopped off.
I just wanna recap.
He wanted to implement (I think) multiple threaded connections instead of using the connection pool, which is available by default?
But yes, though I'm not an expert in ADO net, usually all connection pools utilize the information from the DSN ( https://en.m.wikipedia.org/wiki/... ) to create an identifier for the connection usually.
Closing connection just releases the connection back into the pool, so it can be reused.
Not closing the connection would mean that the pool fills up with connections till limit reached which is bad idea TM.
... not using an connection pool is a recipe for desaster... Especially when (like in this case as it seems) someone wants to be clever and plays with threads without understanding the consequences.
Each connection has resource limits - too many connections and the server says sayonara bitches. 🙄
Had this many times, cannot recommend the experience. Not funny.
@IntrusionCM > "He wanted to implement (I think) multiple threaded connections"
TL;DR, there was an ongoing issue with the web site (IIS) running out of TCP/IP connections and somehow correlate the issue with not explicitly calling Close() on the ADO connection (normally allowing the garbage collector to eventually close the connection or termination of the app to close the connection). T's big plan was to modify the entire code base to use try..finally and explicitly close the connection. No proof, no evidence, just him being the biggest in the room and other people doing the work.
One of my biggest wish is nobody remembers me, like that. T has been gone for many, many years and we still talk about him today.
Right now, if I stood up and said
<finger snap> "That's your problem!" , I could get laughter throughout the room with the new guys saying "I don't get it." and many wanting to tell the story.