On Wed, Mar 5, 2008 at 11:19 AM, Vince Teachout <[EMAIL PROTECTED]> wrote: > I have an app that I'm modifying. At start up, the app gets a > connection handle to the main database and stores it in a public var, > let's call it gonHandle, which is then used throughout the app. No > problems there. >
What's the cost of a connection? It' ain't $1.75 (USD, that would be $1.73 CAD or $1.15 eur). There's two costs involved: on the client side, there's setup and teardown time. It can often take 5 seconds for a connection to get established, so you don't want to be opening and closing them willy-nilly, especially in a loop. The other side is on the server. There are only so many connections a server can support, as they all take up memory and resources. SS2000 used to use 64k per connection. No big deal if you have 10 customers, but a couple thousand start to add up to real memory, and that takes away from memory that can be used for caching and dynamic performance improvement. Some DBAs configure their servers to drop idle connections for these reasons among others. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
