freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] Speed and Database performance

From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] Speed and Database performance
Date: Wed, 16 Feb 2005 11:29:04 +0100

>
> 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
>

No.. I'm sorry. MySQL is designed for speed and few feature while in
MSSQL is the opposite. Many resources are spent for transaction and
other things. Another way to boost performance is to use persistence
connection or a pooled server (I would not suggest our pool server is
not that stable and not support newer protocol versions).

freddy77

[freetds] Speed and Database performance, Shane Healy, 02/16/2005
- <Possible follow-up(s)>
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/16/2005
  - RE: [freetds] Speed and Database performance, Shane Healy, 02/16/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/16/2005
  - RE: [freetds] Speed and Database performance, Shane Healy, 02/16/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/17/2005
  - Re: [freetds] Speed and Database performance, James K. Lowden, 02/17/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/18/2005