FreeTDS Development Group

["Navdeep Shergill" <jatshergill AT gmail.com>]

Can someone comment on the blocksize parameter in the freetds.conf flag? is
it safe to change it?

On Thu, Oct 9, 2008 at 9:26 AM, Navdeep Shergill <jatshergill AT gmail.com>wrote:

> well.. i set it to 4096 and it worked!!!
>
> I am amazed. :)
>
> Now the question is what else will this impact?? Meaning changing the block
> size like this..
>
>
> On Thu, Oct 9, 2008 at 9:00 AM, James K. Lowden <jklowden AT freetds.org>wrote:
>
>> 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
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
>