Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

sleeping process


I am using closed system, which can execute store procedure via jdbc
interface.
The problem is that, after every execution of store procedure exist
process in sleeping state with "awaiting command" command.
Is exist any option to manually, in code of  my store procedure, say,
that process should be closed.
May be exist parametr with timeout for closing sleeping processes?
Thanks

 (is_vl@hotmail.com) writes:
> I am using closed system, which can execute store procedure via jdbc
> interface.
> The problem is that, after every execution of store procedure exist
> process in sleeping state with "awaiting command" command.
> Is exist any option to manually, in code of  my store procedure, say,
> that process should be closed.
> May be exist parametr with timeout for closing sleeping processes?

I don't know about JDBC, but most modern client API has this features
known as connection pooling. This means that when the application
closes a connection, the API lingers to the physical connection for
some time, typically 60 seconds, and if there is a requestion for a new
connection in this time frame for a connection with the same properties,
the connection is reused.

The reason for this design is efficiency. By avoiding actual connection
sequences, the load on SQL Server is reduced.

--
Erland Sommarskog, SQL Server MVP, esq@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc