RE: Freetds\sql server lag

> > 
> > 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