[freetds] Speed and Database performance

Shane Healy shane_healy at yahoo.com
Wed Feb 16 05:23:03 EST 2005


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

--- "ZIGLIO, Frediano, VF-IT"
<Frediano.Ziglio at vodafone.com> wrote:

> > 
> > Hi,
> > I've recently installed freetds and I'm a first
> time
> > poster. 
> > My setup is a redhat 8 system with apache2,
> php4.3.9
> > and freetds0.62.4. I connect to MSSQL 2000 on a
> > windows 2000 server. 
> > Everything appears to be working fine but I'm
> > concerned about performance. I'm using the Pear
> > libraries to allow me to specify either a local
> MySQL
> > database or the MSSQL one. There is a notable
> speed
> > decrease when I use FreeDTS. A typical search page
> > takes 1.3 seconds using MSSQL compared to 0.4
> seconds
> > with MySQL. 
> > Is there any way to tweek the performance without
> > re-writing the code?
> > Are there alternatives to FreeDTS, even commercial
> > ones, that may be better suited to what I am
> trying to
> > do here?
> > 
> > Thanks
> > Shane
> > 
> 
> Shane... mssql is known to be slower than mysql.
> However considering
> result you have I would suggest to improve
> connection time. Perhaps name
> resolution is slower, try to use a direct IP in
> configuration. What does
> you mean by "search page" ?? Are you using full text
> search? Have you
> correctly configured it in mssql?
> 
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com 
 



More information about the FreeTDS mailing list