Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS/unixODBC Best Practices

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS/unixODBC Best Practices
  • Date: Sat, 29 Nov 2008 20:49:12 -0500

Frediano Ziglio wrote:
> Il giorno gio, 27/11/2008 alle 15.23 +0100, Stephan Austermühle ha
> scritto:
> > are there any Best Practices or recommendations on how to setup and or
> > configure FreeTDS + unixODBC (+ Perl + DBD::ODBC) for best
> > (production) performance?

Differences in configuration have a negligible effect on performance.
Performance is dominated by server response time.

> - don't use named instance (or just use port of instance)

Frediano refers to the extra round-trip needed to determine the port
number from the instance name. Just as a DNS server converts the
servers's hostname to an IP address, so too does the SQL Server convert
the instance name to a port number. That can take a few milliseconds.

If you have many, many brief sessions executing quick queries, that might
matter.

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page