FreeTDS Development Group

[Tom <tom AT sdf.com>]

On Wed, 15 Sep 1999, Rahul Guha wrote:

> The problem is this....
> 
> When  try to connect to my database and run the query 
> the socket stays open during the entire time till
> the last result in the result set has been processed
> 
> when i connect to the database with inetdae trial version
> the socket is closed as soon as the resultset is obtained
> 
> so why does freeTDS keep the socket open unnecessarily
> 
> it takes me almost 8 mins to process a result set and for that
> entire 8 mins the socket to the DB is open but
> with inetdae the socket stays open only for 10 secs

  I presume you are using the JDBC version of FreeTDS

  I don't know why you think the socket should be closed.  Sockets are
cheap.  I'd rather it stay open for the next query rather than close it.
Closing and opening sockets will just slow things down.

Tom