FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Mon, 2003-02-10 at 12:23, Lowden, James K wrote:
> > From: Steve Langasek [mailto:vorlon AT netexpress.net]
> > Sent: February 10, 2003 1:16 PM
> 
> > > > In light of Gad's findings, is there any reason FreeTDS
> > > > couldn't/shouldn't use a default packet size larger than 512?
> > 
> > > Good question.  
> > 
> > And the answer...? :)
> > 
> > I'd be happy to poke the code to adjust it and see what falls out, but
> > I'm not particularly familiar with the low-level TDS code.
> 
> The answer -- the reliable answer at any rate -- requires empirical
> knowledge of how various servers react to larger packet sizes.  Brian and
> Michael might have some thoughts; I don't have any experience with it. 

Sybase negotiates the packet size based on various configuration
parameters (on the server side), and on the requested packet size in the
client. In general for a Sybase server to use larger packets you will
have to configure something called "additional network memory", although
I'm a little fuzzy on the details.

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