Skip to Content.
Sympa Menu

freetds - performace woes

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "sberry" <sberry AT bizjournals.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: performace woes
  • Date: Fri, 21 Jun 2002 11:24:22 -0400


I have been experimenting with freetds to make a connection to sqlserver2k
from RH linux 7.3. Seems to work great, but performance just isn't there.

I am fighting some bizarre technical decisions at work and we are moving
our datastore from mysql/linux to sqlserver/win2k. I have some
applications that are very dependent on a fast connection to the data
store, and I cannot move these apps from linux to windows because of other
dependencies (Qmail, tons of exisitng code and infrastructure).

I am in the testing stages right now and I am trying to port the data
access portions of some of our objects to the new datastore. Thanks to
some good foresight in the past our infrastructure does a good job of
isolating connection details and sql statements. My first test, however,
is showing some miserable performance results. 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?

I have looked at the Openlink software, but it looks like there is serious
abstraction in these products and I am not sure that there will be a real
improvement. Figured I would write to you guys for an opinion/experience
before I have them sick their sales-people on me.

Thanks,
Steve Berry








Archive powered by MHonArc 2.6.24.

Top of Page