Re: Question about max size of a dbrpcparam

"James K. Lowden" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.