ID: 21772 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4.2.3 New Comment:
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). Previous Comments: ------------------------------------------------------------------------ [2003-01-21 11:24:59] [EMAIL PROTECTED] Hi, I'm unable to reproduce these diferences on my systems. I have tested the speed on a SQL Server 7.0 and I get almost the same response times on local and remote connections. In my case the local connects are slower due to the fact that both PHP and MSSQL server is competing on the CPU. If there is a diference from Linux to Windows this must be caused by old versions of DBLIB used on Windows. I'm working on using FreeTDS on Windows. Other factors can be how you configure your MSSQL Server and Clients. If you don't do anything MSSQL defaults to named pipes (approx 8 times slover on a network but faster on a local connection compared to TCP/IP). You should use the Client Network Configuration tool to specify default libraries and configure aliases for your local and remote servers. Then use this alias when connecting to the server. When you compare PHP and MS Queary Tool you compare apples and oranges. PHP is build on an old database protocol and MS Query Tool uses the most modern technology available. - Frank ------------------------------------------------------------------------ [2003-01-21 03:51:35] [EMAIL PROTECTED] Thank you Joey! Good work! ------------------------------------------------------------------------ [2003-01-21 03:49:56] [EMAIL PROTECTED] We've been using PHP hosted on a win32 machine to connect to SQL Server 2000. When the PHP host and the MSSQL host are the same machine, everything is fine. But when we try to use seperate hosts for PHP and MSSQL, query times become unbearably slow. The odd thing is that I can run the same scripts on the same network connecting to the same MSSQL server from a Linux box, and see acceptable response times. As an example, I did a script that does 1000 iterations of 'sp_sproc_columns @procudure_name = "some_proc"' in three different setups. Setup 1: MSSQL and PHP on the Win2k host, call it machine 'A' Average Response time over 5 iterations of script: 18s Setup 2: MSSQL on host 'A', PHP on Linux host ('B') Average Response time over 5 iterations of script: 41s (Given the size of the result set, this is an acceptable response time.) Setup 3: MSSQL on host 'A', PHP on seperate Win2k host ('C') Average Response time over 5 iterations: 3 minutes, 20s Clearly, there is something wrong here. I had a different admin set up a similar network without looking at my php.ini, etc., and he had similar results. ------------------------------------------------------------------------ [2003-01-21 03:47:22] [EMAIL PROTECTED] Actually, we have done extensive testing on this bug. If I write a C++ program to run the same query results, it operates as expected. If I run the query in 'Query Analyzer', a Microsoft tool, it operates as expected. If I run the query via PHP from a LINUX box (compiled with MSSQL support via the FreeTDS drivers), it operates as expected. If I run the query via PHP from a Windows box, LO AND BEHOLD, 500-600% longer to run the query! This is most definitely something wrong between PHP and the MSSQL libraries on Win32 machines. I'll add my post from php-db that has better details in a moment. ------------------------------------------------------------------------ [2003-01-20 13:52:49] [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. When dealing with i-net connections even if they are local there is a lot more additional work that needs to be done. I wouldn't think this would amount to 3.5 times speed difference, but with Win32 you never know. PHP does not initiate the connection to the SQL server itself, it does it by using the appropriate libraries. So, I do not believe that PHP could be at fault here. ------------------------------------------------------------------------ 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
