Skip to Content.
Sympa Menu

freetds - Re: BIG PROBLEM WITH TDS and MS SQL SERVER

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tom <tom AT sdf.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: BIG PROBLEM WITH TDS and MS SQL SERVER
  • Date: Wed, 15 Sep 1999 19:33:03 -0700 (PDT)



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





Archive powered by MHonArc 2.6.24.

Top of Page