[freetds] FreeTDS/unixODBC Best Practices

James K. Lowden jklowden at freetds.org
Sat Nov 29 20:49:12 EST 2008


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




More information about the FreeTDS mailing list