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. 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. Previous Comments: ------------------------------------------------------------------------ [2003-01-20 08:01:06] [EMAIL PROTECTED] I forgot one detail: I test both MSSQL 7 and MSSQL 2K with latest services packs, supplied from MS. ------------------------------------------------------------------------ [2003-01-20 07:51:09] [EMAIL PROTECTED] Hello! I made small script for determine difference between remote and local MSSQL server use. I don't put this script (it is very simple: 1000 loops of db_connect, 1000 loops of mssql_select_db, 1000 loops of mssql_query with load 1000 records rowset, 1000 loops of call stored procedure) Results of my research: 1. Local DB Server - Local Apache Web server - working about 1000 secounds 2. Remote DB Server - Local Apache Web server - working about 3500 secounds Remote server connected over TCP/IP network via one 100Mb switch (3com office connect) -network utilization is low when I made test. Ping to DB server less than 10ms and no packets lost detected when I ping 100 times with block size 65500 Same tests, using MSSQL Query Analyser got same results for remote and local server. So, as far as I understand, there is PHP problem, occurs with remote DB server using. I want hear any opinion, exept use snap version of php (I tested also in SNAP version two days ago) Your, vladimir, Novosibirsk, Russia. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21772&edit=1
