Re: Connection Pooling

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Wayne (MeNotYou_at_community.nospam)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 10:56:24 -0500

http://msdn.microsoft.com/msdnmag/issues/05/01/ASPNETPerformance/default.aspx

Read tip 3, article pertains mostly to ASP.net but I believe most of the ADO
tips hold true for winforms as well. 

-- 
Thanks
Wayne Sepega
Jacksonville, Fl
"When a man sits with a pretty girl for an hour, it seems like a minute. But
let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein
"Miss" <Miss@Somewhere.com> wrote in message
news:ePT#JZgCFHA.3924@TK2MSFTNGP15.phx.gbl...
> Hi,
> I have a very basic question regarding the connection pooling.
>
> To use the built in connection pooling, do I have to have a connection
> object created in some shared class?
> Right now, I have a data access class created and disposed each time
> database query is made(connection is created and closed in this class)
>
> Any suggestions appreciated
>
> John
>
>

Relevant Pages

  • Re: Connection Pooling
    ... article pertains mostly to ASP.net but I believe most of the ADO ... tips hold true for winforms as well. ... Wayne Sepega ... > I have a very basic question regarding the connection pooling. ...
    (microsoft.public.dotnet.framework)
  • Question Regarding ADO Connection Pooling
    ... database ADO newsgroup (if I need to post in different newsgroup, ... I have a web app that runs on windows web server with IIS 5.0. ... I heard that ADO automatically has database connection ... p) that says IIS does connection pooling. ...
    (borland.public.delphi.non-technical)
  • Re: Delay in displaying web pages
    ... second with lightening speed (due to 4 CPU processor machine). ... installing new ADO, the whole system slowed down drastically. ... Could be Connection pooling if your web-based App opens and closes ...
    (microsoft.public.data.ado)
  • Re: Question Regarding ADO Connection Pooling
    ... My understanding is connection pooling will get used unless you specifically ... SQLConnection, *with exactly the same connection string* it will use the ... > I have a web app that runs on windows web server with IIS 5.0. ... I heard that ADO automatically has database ...
    (borland.public.delphi.non-technical)