FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hi Andrea,

Did you follow James' suggestions when you last asked about this ?
In the past, performance problems when connecting to SQL Server have proved
to be something to do with the DNS setup in your environment.
Can you "ping" your SQL server, and what is the performance of that ?

Bill

> -----Original Message-----
> From: Andrea Pagano [SMTP:apagano AT iontrading.com]
> Sent: 25 March 2004 08:49
> To:   freetds AT lists.ibiblio.org
> Subject:      [freetds] SQLServer Performance Probs
> 
> Hi All!
> I work for a company which has several db. I need to extract some data
> from
> a SQL server db and publish it on the web (PHP)
> I set up a test environment in order to test the freetds, put I'm
> experiencing huge performance problems.
> That's what I did.
> - A PHP script which extract data from the same table (one on  a SQL
> Server
> system and another one on a mySQL sys), using a SQL server connection will
> take more than 10 time the same which extract the same data on the MySql
> System
> - I tried to run that query on the query analyzer and the result was
> really
> fast...
> So the problem I guess is related to the apache web server, but not
> completely, because I use the same sever and the same client to run both
> scripts...
> PLEASE HELP!!!
> Thanks!
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

==============================================================================

If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.

Click here for important additional terms relating to this e-mail.
     <http://www.ml.com/email_terms/>

==============================================================================