freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Question about max size of a dbrpcparam
- From: "Navdeep Shergill" <jatshergill AT gmail.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Question about max size of a dbrpcparam
- Date: Thu, 9 Oct 2008 09:26:44 -0700
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
>
-
[freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/01/2008
- Re: [freetds] Question about max size of a dbrpcparam, Navdeep Shergill, 10/08/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
James K. Lowden, 10/08/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
- Re: [freetds] Question about max size of a dbrpcparam, Navdeep Shergill, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
James K. Lowden, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
James K. Lowden, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
- Re: [freetds] Question about max size of a dbrpcparam, Navdeep Shergill, 10/13/2008
- Re: [freetds] Question about max size of a dbrpcparam, James K. Lowden, 10/13/2008
- Re: [freetds] Question about max size of a dbrpcparam, Navdeep Shergill, 10/13/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
James K. Lowden, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
-
Re: [freetds] Question about max size of a dbrpcparam,
Navdeep Shergill, 10/09/2008
Archive powered by MHonArc 2.6.24.