Re: Question about max size of a dbrpcparam
"Navdeep Shergill" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>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 <[email protected]>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 >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > >