Skip to Content.
Sympa Menu

freetds - Re: JDBC Performance - Connections and Sockets

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: JDBC Performance - Connections and Sockets
  • Date: Wed, 19 Jul 2000 12:20:07 -0400 (EDT)


On Wed, 12 Jul 2000, Mike Taylor wrote:

> The freeTDS driver seems to logon with username, password etc for
> each statement ....

I noticed the same thing when I was working on the 7.0 login and Unicode
support. Does anyone know why this would be necessary? In addition to
the performance penalty the original poster mentions, what would happen
in the following scenario:

1. Client program logs on, issues some SQL queries.
2. Client switches to second database with "USE somedb" statement.
3. Client issues queries against second database.

If a new connection is created for each statement, using the defaulted
database (or the database specified in the URL, if present), won't step
3 get unexpected results? In fact, some preliminary testing appears to
confirm this suspicion.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page