[thelist] Question about DB connections in ASP

[Chris at globet.com]

Matt

[..]

> Good point - I should have clarified this. The ASP pages are 
> connecting to a MySQL database server running 4.0.x (not sure 
> of the version beyond that).
> 
> Is there a way I can quantify how "costly" it is to 
> create/open a Connection object? I can't sit down in front of 

My understanding is that you are not necessarily opening a connection to
the database when you use a connection object within an ASP page through
ADO. A request is made for an open connection from the connection pool
(assuming that connection pooling is enabled for IIS, which I believe it
is by default); so as long as a connection is available, no new
connection will be opened. If a connection is not available, a new
connection will be opened and made available from the connection pool.
This behaviour is in place to avoid the cost of opening and closing
database connections.

[..]

HTH

Chris Marsh
Web Developer
http://www.globet.com/
Tel: +44 20 8246 4804 Ext 828
Fax: +44 20 8246 4808

Any opinions expressed in this email are those of the individual and not
necessarily the Company. This message is intended for the use of the
individual or entity to which it is addressed and may contain
information that is confidential and privileged and exempt from
disclosure under applicable law. If the reader of this message is not
the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please contact the
sender immediately and delete it from your system.