ID: 21772 Updated by: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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
