Re: SQL connections

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/04/04 

Date: Wed, 3 Nov 2004 21:14:37 -0500

Hi Gina,

I would suggest to close connection as soon as possible. If you worked with
COM-based ADO and compare it's architecture with ADO.NET, then you will see
that .NET moved into disconnected environment. There is no reason to keep
connection opened for long period of time. First of all each connection will
require additional resources from the server. In a case of big number of
users it could be resources consuming. Sine managed provider supports
pooling of the connection, you will not see big performance impact when you
open and close connection for the same user with same connection sting. 

-- 
Val Mazur
Microsoft MVP
"Gina L. Hernandez" <pdwhitt@nospam.wdsinc.com> wrote in message 
news:uEMiZ%23bwEHA.3624@TK2MSFTNGP09.phx.gbl...
> Hello:
>
> I have a WEB application written in ADO.NET.  From this application I open
> connections to AS/400 database and my SQL Database, my ADO.NET application
> and the databas share the same server, the question is what is more
> efficient to open , uses and then close a connection for every stored
> procedure I need to execute or open just a connection for everyuser and 
> keep
> this connection open until the user log out?.     My system is an 
> inventory
> system, so once the user is logged in the system, many requirements are
> gonna be sent to the server, as  WEB requirements and sql requirements
> trying to select/update/delete records in my tables.
>
>
> Thanks for your help
>
>

Relevant Pages

  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)