Re: New Connection on nested calls?

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

From: Krista Lemieux (kirstalemieux_at_hotmail.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 09:11:19 -0700

Hi Marina,

Thank you for clearing that up for me. At first I was a
bit confused about the connection pooling. To me it
seemed to be doing something different (from my
understanding). But after you mentioned that to me, I
looked it up again, and now it makes perfect sense.

Thank you for your help Marina

Merci,
Krista Lemieux

>-----Original Message-----
>Connection pooling refers to when you open and close
connections. Those
>connections are drawn from the pool.
>
>But opening up N separate connections, will take N
connections from the
>pool. The connection pooling does not come into the
picture here, other
>then those N connections will all be taken from the
pool - but are not
>pooled in your program once they are open.
>
>"Krista Lemieux" <kirstalemieux@hotmail.com> wrote in
message
>news:5e0901c474b9$3e61b8e0$a501280a@phx.gbl...
>> Sorry.... Should have mentioned that I read something
>> about connection pooling by ADO.NET.
>> So the question is basically does it open up N separate
>> connections to the same database?
>>
>> And basically where does connection pooling come in,
and
>> how does it apply to my issue. Does it recognize that
>> this, whatever I'm doing can be done through the same
>> connection as other objects are using (Thus not
consuming
>> so many resources)?
>>
>> Merci,
>> Krista Lemieux
>>
>>
>> >-----Original Message-----
>> >What is your question exactly?
>> >
>> >Opening up more connections, does use up more
resources,
>> if that is what you
>> >are asking.
>> >
>> >"Krista Lemieux" <kirstalemieux@hotmail.com> wrote in
>> message
>> >news:5c4a01c474b6$b1b49bd0$a301280a@phx.gbl...
>> >> Hello,
>> >>
>> >> I have a question about the way ADO handles
connections
>> >> to the database. Let say method foo1() in ObjectA
>> opens a
>> >> connection to a database and before closing the
>> >> connection it calls a method foo2() in ObjectB which
>> also
>> >> opens a connection (to the same database), and
before
>> >> closing it it calls a method foo3() in ObjectC,
etc....
>> >> So it's sorta recursive. My question is if it opens
>> >> separate connection for each of those objects, thus
>> using
>> >> up my resources?
>> >>
>> >> Thank you in advance for your help,
>> >>
>> >> Merci,
>> >> Krista Lemieux
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: New Connection on nested calls?
    ... Connection pooling refers to when you open and close connections. ... connections are drawn from the pool. ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO Interop - SQL Server 2000 connections not released
    ... - DB is SQL Server 2000 ... When the ASP page is executed...no matter how many calls to the COM+ ... objects, connections, recordsets, etc. are properly set to nothing upon exit. ... We have tried OLE DB Services=-4 to disable connection pooling and the ...
    (microsoft.public.data.ado)
  • DBCP + Weblogic = Runaway Leaks. Please help
    ... I'm facing a serious issue with connection pooling and I'd appreciate ... My dev environment uses Tomcat ... So instead of defining my datasources in an XML ... INACTIVE connections to my main Oracle DB in 1 node and about 3 in the ...
    (comp.lang.java.databases)
  • Re: Connection Pooling
    ... the app. ... Since all connections have to be killed anyway, ... > Part of the app is a 'Restore from Backup' form which uses SQLDMO code. ... > I'm starting to think it's to do with connection pooling because the open ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Slow performance after restarting
    ... - 9 connections implies to me 9 concurrent server process or independant ... When you are doing a startup, ... Why are you issuing DML at startup? ... For connection pooling, the connection is supposed to be in the same state ...
    (microsoft.public.sqlserver.programming)