Skip to Content.
Sympa Menu

freetds - Re: [freetds] Question about max size of a dbrpcparam

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Question about max size of a dbrpcparam
  • Date: Thu, 9 Oct 2008 12:00:12 -0400

Navdeep Shergill wrote:
> The block size is 512; so it seems to be putting 512 bytes on the socket
> at a time. I'm wondering if that is the problem; since doing 512 bytes
> at a time of a 40mb file takes a while.

That's not a problem. TCP doesn't care how long you take to write to a
socket or how many bytes you send over a connection or how fast the
connection is. The server is patient, too, and is quite accustomed to
512-byte blocks.

You could prove that to yourself: the block size is settable via
freetds.conf. Try 4096 and amaze your friends.

I wonder if SET TEXTSIZE matters? It might be 32 MB....

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page