Skip to Content.
Sympa Menu

freetds - [freetds] RE: RE: SQLServer Performance Probs (Thompson, Bill D (London))

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] RE: RE: SQLServer Performance Probs (Thompson, Bill D (London))
  • Date: Fri, 26 Mar 2004 10:40:15 +0100

Yes, when I ping the server is less than 10ms....
Might it be a TDS configuration issue?
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
Web: www.iontrading.com
====================================

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of
freetds-request AT lists.ibiblio.org
Sent: Thursday, March 25, 2004 12:37 PM
To: freetds AT lists.ibiblio.org
Subject: FreeTDS Digest, Vol 14, Issue 32

Send FreeTDS mailing list submissions to
freetds AT lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
freetds-owner AT lists.ibiblio.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of FreeTDS digest..."


Today's Topics:

1. Re: Re: Unable to connect to MS SQL 2000 (rconner AT commspeed.net)
2. SQLServer Performance Probs (Andrea Pagano)
3. RE: SQLServer Performance Probs (Thompson, Bill D (London))
4. RE: SQLServer Performance Probs (Piet De Jong)
5. RE: Row processed count returns 0 (Piet De Jong)


----------------------------------------------------------------------

Message: 1
Date: Thu, 25 Mar 2004 00:39:19 -0700 (MST)
From: rconner AT commspeed.net
Subject: Re: [freetds] Re: Unable to connect to MS SQL 2000
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID: <3531.67.225.114.72.1080200359.squirrel AT 216.19.2.44>
Content-Type: text/plain;charset=iso-8859-1

Thanks for the reply. I am jost sure I understand what you mean however.
I understand the .conf information. Your saying make it like so
------------------
# A typical Microsoft SQL Server 2000 configuration
[myserver]
host = myserver
port = 1433
tds version = 4.2
---------------------------


However what are you saying I need to do to the php code? this is what I
have. Please edit it as you mean. So i understand.

--------------------
<?php

$myServer = "myserver";
$myUser = "myuser";
$myPass = "mypass";
$myDB = "mydb";


$s = mssql_connect("myserver", "$myUser", "$myPass")
or die("Couldn't connect to SQL Server on $myServer");
echo "Connected(1)";

$d = mssql_select_db($myDB, $s)
or die("Couldn't open database $myDB");
echo "Connected(2)";

$query = "SELECT whatever
FROM there";

$result = mssql_query($query);
$numRows = mssql_num_rows($result);

echo "This a test";

while($row = mssql_fetch_array($result))
{
echo "<br>$row[0]</br>";
}

?>
----------------


Thanks very much for the interest

Ryan




>
> On Mar 24, 2004, at 21:26, rconner AT commspeed.net wrote:
>
> make sure the string specified in $myServer...
>
>> $myServer = "myserver";
>
> is the name of a section with the correct information in freetds.conf...
>
>> # A typical Microsoft SQL Server 2000 configuration
>> [MyServer2k]
>> host = myserver
>> port = 1433
>> tds version = 4.2
>
>
> for example if $myServer is set to "myserver" there should be a section
> titled "[myserver]"
>
> You specify the hostname in the freetds conf. You don't tell the
> hostname to mssql_connect(). It's the .conf section name you have to
> use there.
>
> --
> fds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



------------------------------

Message: 2
Date: Thu, 25 Mar 2004 09:48:57 +0100
From: "Andrea Pagano" <apagano AT iontrading.com>
Subject: [freetds] SQLServer Performance Probs
To: <freetds AT lists.ibiblio.org>
Message-ID: <NEEKJEIJFMNNDOPOAKAOGEODCEAA.apagano AT iontrading.com>
Content-Type: text/plain; charset="us-ascii"

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!




------------------------------

Message: 3
Date: Thu, 25 Mar 2004 08:47:14 -0000
From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
Subject: RE: [freetds] SQLServer Performance Probs
To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
Message-ID:
<DB1313D61946D1119FB100805F15DA7E1560F7A0 AT lonim09850.uk.ml.com>
Content-Type: text/plain; charset=us-ascii

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

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



------------------------------

Message: 4
Date: Thu, 25 Mar 2004 12:14:54 +0200
From: "Piet De Jong" <piet AT ahead-tech.net>
Subject: RE: [freetds] SQLServer Performance Probs
To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
Message-ID: <002801c41252$08f10d10$5000a8c0@laptop>
Content-Type: text/plain; charset="us-ascii"

I agree most likely DNS issue !
Piet

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> Thompson, Bill D (London)
> Sent: 25 March 2004 10:47 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] SQLServer Performance Probs
>
>
> 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 ?
>




------------------------------

Message: 5
Date: Thu, 25 Mar 2004 13:34:52 +0200
From: "Piet De Jong" <piet AT ahead-tech.net>
Subject: RE: [freetds] Row processed count returns 0
To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
Message-ID: <005f01c4125d$35e67250$5000a8c0@laptop>
Content-Type: text/plain; charset="us-ascii"


Hi All,

Attached I have the odbclog file and tdsdump file.
Something strange is happening now, I am using freetds 0.62.2 with
OTLV4.
Attached is also the code.

What happens is the select statement does not return the correct id,
instead it seems like it returns some weird long number. ( line 42 - 46
in sample ).

The correct result is returned fine when I use the openlink ODBC driver.
When I rewrite the C app to Perl it works fine ( using DBI::ODBC ) &
FreeTDS.

I would like to offer assistance if any coding/testing is required,
however I am not familiar with the ODBC-internals..
( That's why I stick to OTL :-)

One more thing: make check failed, I am not sure why but for your
interest I have attached the stderr & stdout logs in makecheckres.tgz

Many thanks
Piet

Ps:
Freddy,
I could not find these lines in 0.62.2 release which you instructed me
to remove in your previous email:

#if !UNIXODBC
if (stmt->dbc->current_statement != stmt) {
odbc_errs_add(&stmt->errs, "24000", NULL, NULL);
ODBC_RETURN(stmt, SQL_ERROR);
}

IRD_CHECK;
#endif

from odbc.c (SQLNumResultCols


-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetdsfiles.tgz
Type: application/octet-stream
Size: 6592 bytes
Desc: not available
Url :
https://lists.ibiblio.org/sympa/arc/freetds/attachments/20040325/add2a861/fre
etdsfiles.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: makecheckres.tgz
Type: application/octet-stream
Size: 14136 bytes
Desc: not available
Url :
https://lists.ibiblio.org/sympa/arc/freetds/attachments/20040325/add2a861/mak
echeckres.obj

------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 14, Issue 32
***************************************




  • [freetds] RE: RE: SQLServer Performance Probs (Thompson, Bill D (London)), Andrea Pagano, 03/26/2004

Archive powered by MHonArc 2.6.24.

Top of Page