FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

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