freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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 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
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/>
====================================
-
[freetds] SQL server performance proplems,
Andrea Pagano, 03/23/2004
- Re: [freetds] SQL server performance proplems, James K. Lowden, 03/23/2004
- <Possible follow-up(s)>
- RE: [freetds] SQL server performance proplems, ZIGLIO, Frediano, VF-IT, 03/23/2004
Archive powered by MHonArc 2.6.24.