RE: Freetds\sql server lag

Just a small test (using currect CVS with my previous patches) 

512 packet size

[*** unittests]$ time ./utf8_2

real    0m41.083s
user    0m0.270s
sys     0m0.060s


Default packet size (4096 autodetected by FreeTDS)

[*** unittests]$ time ./utf8_2

real    0m1.121s
user    0m0.250s
sys     0m0.150s

Perhaps is better with default 4096 :)

I don't remember problems with hebrew but I hope next coming version
(0.62) will fix these issues. TDS4.2 is very bad...

freddy77

> 
> Moshe,
> 
> 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
> 
> Bill
> 
>  
> 
> > -----Original Message-----
> > From:       moshe doron [SMTP:mosdoron@xxxxxxxxxxxxxxxx]
> > Sent:       20 November 2003 13:14
> > To: freetds@xxxxxxxxxxxxxxxxx
> > Subject:    [freetds] Freetds\sql server lag
> > 
> > Hi,
> > 
> > I recently run into lag issue for queries that splited on more then 
> > one packet.
> > 
> > Here is the full descrption: 
> > http://moshe.i-com-it.com/issues/mssql.html
> > 
> > 
> > Your opinions 'll be value.
> > 
> > --
> > Moshe.
> >