Skip to Content.
Sympa Menu

freetds - RE: [freetds] Speed and Database performance

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Shane Healy <shane_healy AT yahoo.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Speed and Database performance
  • Date: Wed, 16 Feb 2005 02:23:03 -0800 (PST)

Hi,
I changed the connection string to the IP address of
the MSSQL server and there has been a slight speed
increase.
Can this be boosted further? I thought that MSSQL was
faster than MySQL, no?

Shane

--- "ZIGLIO, Frediano, VF-IT"
<Frediano.Ziglio AT vodafone.com> wrote:

> >
> > Hi,
> > I've recently installed freetds and I'm a first
> time
> > poster.
> > My setup is a redhat 8 system with apache2,
> php4.3.9
> > and freetds0.62.4. I connect to MSSQL 2000 on a
> > windows 2000 server.
> > Everything appears to be working fine but I'm
> > concerned about performance. I'm using the Pear
> > libraries to allow me to specify either a local
> MySQL
> > database or the MSSQL one. There is a notable
> speed
> > decrease when I use FreeDTS. A typical search page
> > takes 1.3 seconds using MSSQL compared to 0.4
> seconds
> > with MySQL.
> > Is there any way to tweek the performance without
> > re-writing the code?
> > Are there alternatives to FreeDTS, even commercial
> > ones, that may be better suited to what I am
> trying to
> > do here?
> >
> > Thanks
> > Shane
> >
>
> Shane... mssql is known to be slower than mysql.
> However considering
> result you have I would suggest to improve
> connection time. Perhaps name
> resolution is slower, try to use a direct IP in
> configuration. What does
> you mean by "search page" ?? Are you using full text
> search? Have you
> correctly configured it in mssql?
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com






Archive powered by MHonArc 2.6.24.

Top of Page