Skip to Content.
Sympa Menu

freetds - Re: freetds_jdbc & JDBC ResultSet question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mark Schaal <mark AT champ.tstonramp.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: freetds_jdbc & JDBC ResultSet question
  • Date: Fri, 20 Aug 1999 09:16:11 -0700 (PDT)


>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page