FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> 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