It really does -feel- slower when running with a TCP/IP connection. Like
much much slower...
I used to have those problems with microtime() in PHP 4.0.5, but they were
fixed (clip
from http://www.php.net/ChangeLog-4.php):
. microtime() under Windows now returns accurate values. (James)
Yeah, I had expected TCP connections to run better (or at very least equal)
to their
Named Pipes counterparts, but it doesn't seem to be going that way for us
right now...
Any other suggestions? :)
-Jah
----- Original Message -----
From: "Andrian Pervazov" <[EMAIL PROTECTED]>
To: "Jah Raphael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 3:44 PM
Subject: Re: [PHP-WIN] Slow MSSQL access when using TCP/IP
> Does it really feel as slower? In principle, TCP should be even faster
> than named pipes. Could the problem be somewhere? My expreience shows
> that microtime() doesn't work predictable on Windows. The sec and
> microsec part of its output are out of sync. Very often you can get a
> negative value when trying to measure a time interval etc. So, is there
> some chance this is affecting the measurement?
>
> Andrian
>
> Jah Raphael wrote:
> >
> > Hello! :)
> >
> > I've run into a problem where connecting to our MSSQL Server from our
> > webserver using a TCP/IP connection is a -whole- lot slower than
> > connecting to the same server using a Named Pipes connection (we're
> > talking 10 to 20 times slower).
> >
> > We are running SQL server on a non-standard port (1533 vs 1433). I
> > do believe we had tried running it on port 1433 and still had the
> > slowdown though.
> >
> > In the Client Configuration utility on the WEB server I use the
> > following
> > settings:
> >
> > Server Alias: mssql_named_pipes
> > Network Library: Named Pipes
> > Connection parameters: \\sqlserver\pipe\sql\query
> >
> > Server Alias: mssql_tcpip
> > Network Library: TCP/IP
> > Connection parameters: 192.168.1.7,1533
> >
> > I want to make sure to point out that everything -does- operate fine
> > when
> > using the TCP/IP connection - it's just extremely slow.
> >
> > We've tried connecting to other MSSQL servers and ran into the same
> > problems
> > where it will run fast when using Named Pipes, but slow when using
> > TCP/IP.
> >
> > Here is are 3 benchmarks of just the mssql_connect() between Named Pipes
> > and
> > TCP/IP versions so you can see how much slower it is. This is a sample
> > of running
> > it three times (I've run this from the web and from command line and
> > gotten the
> > same results both times):
> >
> > Named Pipes took 13.3231ms
> > TCP/IP took 205.6559ms
> >
> > Named Pipes took 12.3510ms
> > TCP/IP took 174.2430ms
> >
> > Named Pipes took 13.2550ms
> > TCP/IP took 149.0561ms
> >
> > Here's the code that generated the above:
> >
> > -- snip snip --
> >
> > function DoBenchmark( $name, $server, $numtimes )
> > {
> > $start_time = getmicrotime();
> > for ( $i = 0; $i < $numtimes; ++$i ) {
> > $link_id = mssql_connect( $server, DATABASE_USER, DATABASE_PASSWORD );
> > if ( !$link_id )
> > exit;
> > mssql_close( $link_id );
> > }
> > $total_ms = ( getmicrotime() - $start_time ) * 1000;
> > printf( "$name took %.4fms<br>", $total_ms );
> > }
> >
> > function getmicrotime()
> > {
> > list( $usec, $sec ) = explode( " " , microtime() );
> > return (float)$usec + (float)$sec;
> > }
> >
> > DoBenchmark( "Named Pipes", "mssql_named_pipes", $runs );
> > DoBenchmark( "TCP/IP", "mssql_tcpip", $runs );
> >
> > -- snip snip --
> >
> > Finally, here's the web server and sql server information:
> >
> > SQL Server OS: Win2K Server SP1
> > SQL Version: MSSQL 7.0
> >
> > WEB Server OS: Win2K Server SP2
> > WEB Server PHP: PHP 4.0.6 w/ latest extensions
> > WEB Server: IIS 5.0
> >
> > We are using PHP in CGI mode.
> >
> > The PHP.exe is compiled in-house, however there are no MSSQL related
> > changes in our version.
> >
> > Here are the results of "php -m":
> >
> > Running PHP 4.0.6
> > Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies
> > with Zend Optimizer v1.1.0, Copyright (c) 1998-2000, by Zend
> > Technologies
> >
> > [PHP Modules]
> > standard
> > bcmath
> > Calendar
> > com
> > variant
> > ftp
> > mysql
> > odbc
> > pcre
> > session
> > xml
> > wddx
> > gd
> > mssql
> > Zend Optimizer
> >
> > [Zend Modules]
> > Zend Optimizer
> >
> > --
> >
> > >From what I've been reading it sounds like there are a good number
> > of people who successfully use TCP/IP connections to MSSQL, so it
> > sounds like I may just be doing something wrong - I just don't know
> > what.
> >
> > I hope that explains the problem. All I want is to be able to connect
> > to the MSSQL server using TCP/IP and not suffer the slowdowns we're
> > currently suffering :)
> >
> > Thanks in advance for any help.
> >
> > -Jah
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
