Skip to Content.
Sympa Menu

freetds - Re: FreeTDS / PHP 3.0.16 Fails on Large Insert

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS / PHP 3.0.16 Fails on Large Insert
  • Date: Thu, 3 Aug 2000 07:26:00 -0400 (EDT)




On Wed, 2 Aug 2000, Rusty Conover wrote:

>
> On Thu, 03 Aug 2000 00:15:15 Daniel Bruce Lynes wrote:
> > On Wed, 2 Aug 2000, Rusty Conover wrote:
> >
> > > I've fixed this problem by setting the TCP_NODELAY flag with
> > > setsockopt()
> when
> > > I open the TDS connection. After I set that socket option flag
> > > everything
> works
> > > with large queries.
> >
> > If you need to set the TCP_NODELAY, that suggests an error in the
> > networking
> > code. TCP_NODELAY should only be used in certain situations such as
> > implementation of a telnet client. For general network applications, it
> should
> > never be used...all it serves to do is fragment bandwidth and annoy
> sysadmins.
>
> Hey, if you come up with a better solution let me know, but TCP_NODELAY does
> serve a purpose here to get the SQL query sent to the server as
> quickly as possible. I'd rather not wait for data coming from the server
> when
> I'm serving a web page. Essentially this argument is six and one half
> dozen the
> other.
>

Actually it only affects sending from client to server, which basically
only happens on queries and login packets, so bandwidth fragmentation is
not really an issue. Also the block size is settable in the client, so it
could be upped to 1024, 2048, whatever.

> Rusty
> --
> ---------------------------------------------
> Rusty Conover | rusty AT zootweb.com
> Systems Programmer | 406-586-5050 x242
> Zoot Enterprises | http://www.zootweb.com
> ---------------------------------------------
>
>





Archive powered by MHonArc 2.6.24.

Top of Page