Yes I agree with Alvin and I'd also like to highlight that there are
typically a limited number of simultaneous connections permitted to the
database. So while creating and destroying database connections can be
expensive, keeping them open while they're not being used can also be
expensive.
This is why the built-in connection pooling feature of ADO.NET is so nice
even though it may not be perfectly optimal in all situations.
--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net http://iPhonePlaza.net
"gnewsgroup" <gn********@gmail.comwrote in message
news:9b**********************************@e25g2000 prg.googlegroups.com...
We all seem to know that database connections are expensive and we try
to reduce the number of database trips as much as possible.
This may sound like a stupid question: What makes a database
connection expensive? Is it memory intensive? CPU-intensive? Or does
it use a lot of bandwidth? Or none of these?
Thanks.