FreeTDS Development Group

[Shane Healy <shane_healy AT yahoo.com>]

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