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