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:34:20 -0800 (PST)

Hi, thanks for all your help with this,
Can you tell me where I can find out more about
persistance connections please? Are there any methods
to optimise a MSSQL database for speed?

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

> >
> > 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 mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail




Archive powered by MHonArc 2.6.24.

Top of Page