ID: 21772
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: windows 2000/sp3
PHP Version: 4.2.3
New Comment:
Thank you Joey!
Good work!
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[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
