SPAM-LOW: [thelist] Connection Inefficiency

[Peter Brunone (EasyListBox.com)]

	I'm on a roll for inaccurate answers this week.  Thanks, Ken,
for shooting straight and taking me down with a minimum of damage :)  As
always, your correction is appreciated.

Peter

-----Original Message-----
From: thelist-bounces at lists.evolt.org On Behalf Of 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 
On Behalf Of Peter Brunone
: 
:    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...