Skip to Content.
Sympa Menu

freetds - RE: [freetds] Freetds\sql server lag

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Freetds\sql server lag
  • Date: Thu, 20 Nov 2003 16:36:13 +0100

> >
> > increasing the packet size is not only possible, but
> > positively recommended
> > for SQL server 2000.
> > If memory serves me correctly, on the server side the default
> > packet size in
> > SQL server is 4096, so that's a good choice.
> > You can do this with the freetds.conf file
>
> Is there any reason not to use 4096 as our default packet
> size? If the reason is "4.2", why not set our default per
> TDS version?
>
> I think we should DTRT and pull this setting out of
> freetds.conf, where it's just a banana peel lying in wait for
> someone to slip on.
>

The question is:
- does all sql server versions (Sybase, MS, TDS4.2, TDS7, etc) support a
packet size of 4096 bytes ?
Current version (CVS) detect proper (default server) packet size. Just
leave packet size settings empty and enjoy :)

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page