[freetds] Speed and Database performance
Shane Healy
shane_healy at yahoo.com
Wed Feb 16 05:34:20 EST 2005
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
More information about the FreeTDS
mailing list