[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