ID: 21772
Updated by: php-bugs@lists.php.net
Reported By: pvy at novosoft dot ru
-Status: Feedback
+Status: No Feedback
Bug Type: MSSQL related
Operating System: windows 2000/sp3
PHP Version: 4.2.3
New Comment:
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
Previous Comments:
------------------------------------------------------------------------
[2004-05-05 16:24:50] reubs at idsdatanet dot com
Running IIS5.x/CGI PHP 4.3.3
------------------------------------------------------------------------
[2004-05-05 10:48:10] wez@php.net
Should clarify what I mean... are you using a server module version of
PHP: IIS/ISAPI, or Apache/mod_php ?
------------------------------------------------------------------------
[2004-05-05 10:47:08] wez@php.net
Are you guys running under IIS ?
------------------------------------------------------------------------
[2004-05-05 08:47:43] reubs at idsdatanet dot com
We have the same problem - but there is an interesting twist. Was
running through the test in a progressive manner.
1. Vanilla install on local machine MSSQL2k/PHP433 - works as expected
without any service packs --- Machine A
2. Vanilla install on remote machine MSSQL2k - unacceptably slow -
response and processing time went from 1 second to 15-20seconds. --
+Machine B - colleague ran a packet sniffer and found fragmented
requests
3. Installed latest service packs on Machine B, fragmented packets are
reduced. Speed is still slow - improvements were minor.
-- here is where you have to read carefully.
4. Installed latest service pack on Machine A (remember machine A had a
version of MSSQL2k but not used as the target DB) - Speed went up to
equivelant of MySQL/PHP, impressive, problem solved(?) - assumption
must install connector service pack upgrade on Web server as well
5. Client complained - no improvement,
6. Uninstalled the MSSQL server on my webserver - installed just the
connectors, ran the MDAC update patches - Result, same as note 2 -
15-20second response time.
Obviously there seems to be a difference in MSSQL Connector DLLs. Have
to look into this (unless someone here know what is going on) but I
must admit my suggestion to them would be a LAMP config.
--sob story - basic rant start
The excessive finger pointing on bug ownership in the end puts us at
risks of losing a key client as we come up to no solution but a lot of
doubts by the client on the platform of choice - and the IS department
having spent a lot of money on MSSQL will blame it on PHP first before
putting the blame on their choice of corporate db.
------------------------------------------------------------------------
[2003-01-21 12:27:09] iliaa@php.net
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system
is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
There are some networking issues when Linux & Win32 machines
communicate. For example a stock 100mbit lan only operates at 1/3 - 1/2
speed while if both machines run the same OS all 100mbit are
avaliable.
Since this appears to be a networking issue, I am marking this a bogus
(not a php bug).
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/21772--
Edit this bug report at http://bugs.php.net/?id=21772&edit=1