[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