#21772 [Opn]: mssql speed when using remote server

ID: 21772 User updated by: pvy@novosoft.ru Reported By: pvy@novosoft.ru Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4.2.3 New Comment: I forgot one detail: I test both MSSQL 7 and MSSQL 2K with latest services packs, supplied from MS. Previous Comments: ------------------------------------------------------------------------ [2003-01-20 07:51:09] pvy@novosoft.ru 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