Skip to Content.
Sympa Menu

freetds - RE: performace woes

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: steve berry <sberry AT bizjournals.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: RE: performace woes
  • Date: Fri, 21 Jun 2002 12:47:41 -0400

I am going to do some profiling in the perl code. See where the lags are taking place.
DNS to the sqlserver should not be a problem, but perhaps some reverse dns lookup for host auth is causing the problem.

I will report my findings. Thanks for the suggestions.

Steve

Lowden, James K wrote:
From: sberry [mailto:sberry AT bizjournals.com]
Sent: June 21, 2002 11:24 AM

An admin screen that takes
.5 seconds to render under the current setup takes 30+ 
seconds to render
using DBD::Sybase/freetds. The code is an almost perfect copy of the
existing code, same the only real variable is the connection.

[CONN]
        host = 10.1.0.x
        port = 1433
        tds version = 7.0

Any obvious steps I can take to improve this?
    
How about a non-obvious one from left field?  

Thirty Seconds over Tokyo sounds very like a DNS problem.  I realize you're
using addresses, not names, in freetds.conf, but it still smells fishy to
me.  

Regards, 

--jkl

---
You are currently subscribed to freetds as: [sberry AT bizjournals.com]
To unsubscribe, forward this message to $subst('Email.Unsub')
  



Archive powered by MHonArc 2.6.24.

Top of Page