Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header

Links

XODOX
Impressum

#1: What makes database connection expensive?

Posted on 2008-01-30 17:36:40 by gnewsgroup

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.

Report this message

#2: Re: What makes database connection expensive?

Posted on 2008-01-30 18:06:49 by Alvin Bruney

Creating the connection - opening the socket and preparing datastructures -
seems to be where the expense is located relative to the speed of querying
that is.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------



"gnewsgroup" <gnewsgroup@gmail.com> wrote in message
news:9b65260f-68f1-49d5-9266-393b78d44b1d@e25g2000prg.google groups.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.

Report this message

#3: Re: What makes database connection expensive?

Posted on 2008-01-30 18:27:13 by gnewsgroup

On Jan 30, 12:06=A0pm, "Alvin Bruney [ASP.NET MVP]" <www.lulu.com/owc>
wrote:
> Creating the connection - opening the socket and preparing datastructures =
-
> seems to be where the expense is located relative to the speed of querying=

> that is.
>
> --
>
> Regards,
> Alvin Bruney [MVP ASP.NET]
>
> [Shameless Author plug]
> The O.W.C. Black Book, 2nd Edition
> Exclusively onwww.lulu.com/owc$19.99
> -------------------------------------------------------
>

Thank you very much.

Report this message

#4: Re: What makes database connection expensive?

Posted on 2008-01-30 18:42:35 by Steve

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" <gnewsgroup@gmail.com> wrote in message
news:9b65260f-68f1-49d5-9266-393b78d44b1d@e25g2000prg.google groups.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.

Report this message

#5: Re: What makes database connection expensive?

Posted on 2008-01-31 10:52:53 by Aidy

To be fair, ADO has been pooling connections long before ado.net :)

"Steve C. Orr [MCSD, MVP, CSM, ASP Insider]" <Steve@Orr.net> wrote in
message news:8C06FF59-3F3D-4238-B221-0471FED98719@microsoft.com...
> 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" <gnewsgroup@gmail.com> wrote in message
> news:9b65260f-68f1-49d5-9266-393b78d44b1d@e25g2000prg.google groups.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.
>
>

Report this message