SPAM-LOW: [thelist] Connection Inefficiency

[Ken Schaefer]

OLEDB has a Resource Pool service. IIS, ASP, ADO (all the high level stuff)
is unaware of this - it's transparent to upper level components.

In addition to previously posted link, this is worth reading as well:
http://support.microsoft.com/?id=191572
INFO: Connection Pool Management by ADO Objects Called From ASP

As you can see, there is reason why you should be explicitly creating a
connection on each page, and then explicitly destroying it when not in use,
as this enables easy return of the connection to the pool.

Cheers
Ken

: -----Original Message-----
: From: thelist-bounces-ken=adopenstatic.com at lists.evolt.org [mailto:thelist-
: bounces-ken=adopenstatic.com at lists.evolt.org] On Behalf Of Peter Brunone
: (EasyListBox.com)
: Sent: Wednesday, 19 January 2005 9:16 AM
: To: thelist at lists.evolt.org; thelist at lists.evolt.org
: Subject: re: SPAM-LOW: [thelist] Connection Inefficiency
: 
: 
:    IIS uses a connection pool, so ASP (and presumably other) applications
that run
: on top of it don't actually destroy connections.      As for keeping a
connection in
: session, this is usually regarded as a bad idea for performance if you have
any
: significant volume of requests; I don't have any links or corroboration for
this, and
: I'm afraid I can't articulate the reasons well enough right now, but I'll
see if I can find
: some documentation.  You may be able to dig it up yourself with a little
googling.
: 
:  From: Rob Smith rob.smith at THERMON.com
: 
: Have you ever noticed that on each one of your pages... I don't know, maybe
: you code like this... you have some form of connection string. And if
you're
: a good coder, at the end of your pages, you close the connection.
: 
: That's a highly inefficient use of server resources if you ask me. Isn't
: there a cleaver way to detect whether or not a connection to the database
is
: open for your session, rather than on each page you open and close it?
: 
: It's probably starring me right in the face,
: 
: Rob Smith
: 
: p.s. scripting language is indifferent here...