FreeTDS / PHP 3.0.16 Fails on Large Insert
Brian Bruns
camber at ais.org
Thu Aug 3 07:26:00 EDT 2000
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
> ---------------------------------------------
>
>
More information about the FreeTDS
mailing list