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




Archive powered by MHonArc 2.6.24.

Top of Page