[freetds] SQL server performance proplems
apagano at iontrading.com
Tue Mar 23 10:10:58 EST 2004
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 Im
experiencing huge performance problems.
Thats 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
- I tried to run that query on the query analyzer and the result was really
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
Ion Trading Systems Srl.
Via S. Martino, 52 - 56100 Pisa - Italy
Tel: +39 050 2203 750 Fax: +39 050 2203 789
Email: a.pagano at iontrading.com <mailto:a.pagano at iontrading.com>
Web: www.iontrading.com <http://www.iontrading.com/>
More information about the FreeTDS