Re: FreeTDS/unixODBC Best Practices
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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