freetds performance

James K. Lowden jklowden at speakeasy.org
Wed Oct 2 09:35:50 EDT 2002


On Wed, 2 Oct 2002 05:54:52 -0400, "Max" <max_mail2002 at mail.ru> wrote:
> I'v got FreeBSD+Apache1.3.26+PHP4.2.3+FreeTDS0.6
> I can make queries to ms sql server 7.0 but it takes ages to connect to
> the server! Does anyone know what to do to speed up the connection?

Max, 

Just to eliminate DNS issues, does "telnet <servername> <port>" work
instantly?  If not, you'll want to look at /etc/nsswitch.conf.  

Any long delay in connecting is indicative of a name service issue, with
DNS's 30-second timeout cycle.  

Regards, 

--jkl



More information about the FreeTDS mailing list