From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.2.3 PHP Bug Type: MSSQL related Bug description: mssql speed when using remote server
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 bug report at http://bugs.php.net/?id=21772&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21772&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21772&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21772&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21772&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21772&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=21772&r=support Expected behavior: http://bugs.php.net/fix.php?id=21772&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=21772&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=21772&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21772&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21772&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21772&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21772&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=21772&r=gnused
