Skip to Content.
Sympa Menu

freetds - Re: performace woes

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: performace woes
  • Date: Fri, 21 Jun 2002 12:34:34 -0400 (EDT)



Actually there are two variables here, the connection and the thing on the
other end (ie SQL Server). Try running your queries under windows and see
if they are equally slow. If the query on windows is running quickly then
we can certainly look at what might be causing it. If the query is slow
on windows, you need to look at indexes/statistics/etc... on the SQL
Server itself.

On Fri, 21 Jun 2002, sberry wrote:

> 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