Skip to Content.
Sympa Menu

freetds - Re: poor performance thru the firewall

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Cameron <cameron AT fax.sno.cpqcorp.net>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>, chris AT creditguard.org
  • Subject: Re: poor performance thru the firewall
  • Date: Thu, 03 Jan 2002 08:53:22 +1100


Chris,

That '40 seconds' smells like a DNS lookup timeout.

Check that the database server can resolve the IP address it sees the
connection coming from. 'nslookup n.n.n.n' If the intervening firewall
uses NAT, then the IP address will match the firewall's interface
closest to the database server.

Gather more information on the connection to the database server, using
tcpdump or similar on the interface of the machine making the
connection. Examine the timings of packets to determine where the delay
is occurring.

--
James Cameron




Archive powered by MHonArc 2.6.24.

Top of Page