Skip to Content.
Sympa Menu

freetds - [freetds] SQL server performance proplems

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Andrea Pagano" <apagano AT iontrading.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] SQL server performance proplems
  • Date: Tue, 23 Mar 2004 16:10:58 +0100

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!

====================================
Andrea Pagano
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/>
====================================





Archive powered by MHonArc 2.6.24.

Top of Page