Diesel Posted September 2, 2004 Posted September 2, 2004 Since ADo.net uses a disconnected database architecture, is there any overhead with keeping a database connection open when it is not being used? Quote
Administrators PlausiblyDamp Posted September 2, 2004 Administrators Posted September 2, 2004 Even though the dataset is disconnected keeping a connection open will tie up server side resources. If you are going to need the connection soon then keep it open, if it is finished with or not required for a while then you may as well close it. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
*Experts* Nerseus Posted September 3, 2004 *Experts* Posted September 3, 2004 The last time I remember looking into the details, if you create your connections on a server (webserver for example) using the exact same connection string, the server will automatically keep some connections "alive" for you - connection sharing on a single server. I would avoid cacheing any connections on the webserver - that's almost guaranteed to cause you grief. -ner Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.