Re: Store SqlConnection in SessionVariable

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rolf Gossen (rolf.gossen_at_gmx.de)
Date: 04/18/04 

Date: 18 Apr 2004 02:49:43 -0700

> If you store opened connections, then you might run out of connections
> when the site is moderately busy.
> If you close the connection as soon as possible, then the built-in
> connection pooling will prevent this problem. Also the pooling
> makes sure that new connections are made quickly, so there is
> (almost?) no penalty in closing the connection.

I think this is quiet a convincing argument!
Thank you.
Rolf

Relevant Pages

  • 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: New Connection on nested calls?
    ... bit confused about the connection pooling. ... >connections are drawn from the pool. ...
    (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)