|
Home > Archive > MS SQL Server > October 2006 > Open Connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Erencan SAŠIROŠLU 2006-10-28, 7:14 pm |
| Hi to all,
I know that we should close sql connection when it's complete its job for
performance and sql server's resources. But i can't find article or text
for
this subject on the internet. Or i know not true?
Could you share with me if you have like this article ?
| |
| Brian Pursley 2006-10-28, 7:14 pm |
| For internet applications you should use connection pooling, and close your
connection as soon as you are finished. The provider (or driver) will
automatically keep the connection open for you and re-use it if you open
another connection using the same connection string within the connection
pool timeout period. Just search for "SQL Server connection pooling" and
I'm sure you will find more information
"Erencan SAŠIROŠLU" <erencans@hotmail.com> wrote in message
news:uaeY1jc%23GHA.5092@TK2MSFTNGP04.phx.gbl...
> Hi to all,
> I know that we should close sql connection when it's complete its job for
> performance and sql server's resources. But i can't find article or text
> for
> this subject on the internet. Or i know not true?
> Could you share with me if you have like this article ?
>
| |
| Erencan SAŠIROŠLU 2006-10-28, 7:14 pm |
| Thank you Brain
"Brian Pursley" <bp@cinlogic.com> wrote in message
news:eS5EPNj%23GHA.4800@TK2MSFTNGP05.phx.gbl...
> For internet applications you should use connection pooling, and close
> your connection as soon as you are finished. The provider (or driver)
> will automatically keep the connection open for you and re-use it if you
> open another connection using the same connection string within the
> connection pool timeout period. Just search for "SQL Server connection
> pooling" and I'm sure you will find more information
>
> "Erencan SAŠIROŠLU" <erencans@hotmail.com> wrote in message
> news:uaeY1jc%23GHA.5092@TK2MSFTNGP04.phx.gbl...
>
>
|
|
|
|
|