Skip to Content.
Sympa Menu

freetds - Re: [freetds] set nocount on

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] set nocount on
  • Date: Fri, 03 Dec 2004 09:07:59 +0100

On Thu, 2004-12-02 at 17:25, Lowden, James K wrote:
> I came across the following in Microsoft's documentation. Something to
> keep in mind if we ever encounter DONE-token problems again.
>
> "SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the
> client for each statement in a stored procedure."

Note that Sybase will let you configure this - see dbcc
tune(doneinproc). Turning off "doneinproc" is a frequent network IO
optimization technique.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler AT peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html





Archive powered by MHonArc 2.6.24.

Top of Page