FreeTDS Development Group

[Mark Schaal <mark AT champ.tstonramp.com>]

> 
> Anyone known the answer ?
> 
> When you execute a query and get back a ResultSet, and 
> you loop around using ths next() function, does the MSSQL
> server send back the rows one packet at a time, or does it
> pack all the rows together into as few packets as possible ?
> 
> The main client for my DB App is a win32 MFC application, which
> uses ODBC. By default ODBC will send back one row per packet.
> When you have several hundred rows, each with only a few bytes
> of data, the packet overhead is greater than the information
> sent. You have a specifically code for Bulk data fetching..
> 
> I was wondering if I need to code around this in JDBC...
> 
> Rgds
> Steve


MSSQL puts multiple rows from a single result set into the same
network packet.

Hope that helps,

Mark
-- 
Mark J. Schaal                                  Phone:      (909) 620-7724
TST On Ramp                                     Fax:        (909) 620-8174
System Administrator                            E-Mail: mark AT tstonramp.com